Re: Transferring MySQL data.

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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


--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux