Jump to content

testing server


Woodburn2006

Recommended Posts

ok will have a look, if i connect remotely then it is harder to make changes to a working site. i will have to keep uploading everytime i make a slight change in code and if i am doing a tricky bit i always do a bit at a time and test, it will take to long if i have to upload it all of the time
Link to comment
https://forums.phpfreaks.com/topic/20649-testing-server/#findComment-91809
Share on other sites

It looks like he just wants to be able to copy the local db to the remote db once. By "without having to re-build", I think he means without having to recreate all the tables by hand and enter all the information as he did on his local server.

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
[code]
mysqldump --opt dbname > file.sql
[/code]

Restore on production server
[code]
mysql dbname < file.sql

//or as a query
SOURCE /path/to/file.sql
[/code]

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.

In linux
[code]
mysqldump --opt dbname | gzip -c > file.sql.gz
[/code]
Link to comment
https://forums.phpfreaks.com/topic/20649-testing-server/#findComment-91898
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.