Re: Transferring MySQL data.
| From: | James Hughbanks | Date: | Fri, 15 Aug 2003 22:07:47 +0000 |
| Subject: | Re: Transferring MySQL data. | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-29914@lists.php.net to get a copy of this message | ||
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 transferred the backup file to your production box.
If you need anything else, let me know
--James Hughbanks
Mikro-Data Engineering Dept.
support@mikro-data.net
1-866-457-6287
http://www.mikro-data.net
On Friday, Aug 15, 2003, at 17:28 America/New_York, Hugh Dickinson wrote:
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, Hugh Dickinson