Saving Databases

[rmacca]

Hi,

Can ne1 tell me how to save MySQL databases so that i can transfer them between computers or onto a web server from my personal computer?
What about making backups of a MySQL database?

L8az, Rob

[Anarchos]

Use mysqldump

[7stud]

If I develop my database locally is it possible to upload the contents of the tables into the database held at my hosting company using PHPAdmin.


Reply To This Message
RE: Local Table upload
Author: prosper (210.176.120.---)
Date: 03-12-2001 03:08

select View dump (schema) of database from phpMyAdmin in your local machine.
Then select Structure and data and click "go" button.
And copy the data under the following line from result page
# Dumping data for table ...
insert ...
insert...

Then paste these insert statements into the following text area under the words"
Run SQL query/queries on database mysql" in PhpMyadmin at the company hosting your webpage. These procedure will only copy the data to your table website.

If you don't have any table on the website , you should copy the structure of the table and those insert statements.