Posted 13 September 2006 - 07:10 PM
is there any way of replicating my mysql database from my machine to the server without having to re-build the mysql database on the server?
Posted 13 September 2006 - 07:14 PM
Posted 13 September 2006 - 07:25 PM
Posted 14 September 2006 - 04:00 PM
Posted 14 September 2006 - 05:48 PM
Posted 14 September 2006 - 06:00 PM
Posted 14 September 2006 - 06:57 PM
If that's the case then using PhpMyadmin's export option as mentioned earlier in the thread should be what you're looking for. I'm not very familiar with PhpMyadmin, but it should be a straight forward process.
Instead of using Phpmyadmin, you can do it by hand using "mysqldump" and "mysql" to do the copy.
Backup on test server
mysqldump --opt dbname > file.sql
Restore on production server
mysql dbname < file.sql //or as a query SOURCE /path/to/file.sql
You can compress the sql file to make it much smaller and upload the compressed file. There should also be a similar option in Phpmyadmin.
mysqldump --opt dbname | gzip -c > file.sql.gz
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users