I'd like to transfer a database from one server to another, using PhpMyAdmin (the only way I can manae the database)...
Only problem is I don't know how to do it.
The database isn't gigantic, so perhaps an idea would be to download it and upload it on the other server, but can this be done ? Any SQL wizards to give me an hand ? :)
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 ...
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.