Re: [PHP-DB] Transferring MySQL data.

2003-08-15 Thread James Hughbanks
Hugh, Nothing is a stupid question. you can transfer databases by doing a Machine# mysqldump -a -c -p insert_db_name_here > backup.sql on your home machine, and then doing a Machine_prod# mysqladmin -p create database_name Machine_prod# mysql -p database_name < backup.sql after you have transferre

[PHP-DB] Transferring MySQL data.

2003-08-15 Thread Hugh Dickinson
This is probably a stupid question, but I'm pretty new at this! Having built test MySQL databases for my website on my home machine, is it possible to transfer the data straight to a web hosting company's server or do I need to rebuild the databases again from scratch? Thanks for any input, Hu