You can see more in-depth descriptions in the documentation, but for a simple shot at migrating data and database structures from one machine to another, you can try:
Prompt> mysqldump --add-drop-table <<lots of variety here>> -uroot -ppassword | mysql --host=new.host.ip.add -uroot -ppassword You can dink around with the GUI's, but the std command line tools will get you there just fine... :-) -----Original Message----- From: Tim Winters [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 04, 2003 3:09 PM To: [EMAIL PROTECTED] Subject: RE: NEWBIE QUESTION: Copying Databases from local to server Thanks everyone for the replies. I know I should probably be using phpMyadmin or the command line to export my info out of my local mySQL setup but... I'm using mySQL control center. Using this tool I can't seem to export. There is a button to do it but it is always greyed out. Is there a step I'm missing? thx Tim Winters Creative Development Manager Sampling Technologies Incorporated 1600 Bedford Highway, Suite 212 Bedford, Nova Scotia B4A 1E8 www.samplingtechnologies.com [EMAIL PROTECTED] [EMAIL PROTECTED] Office: 902 450 5500 Cell: 902 430 8498 Fax:: 902 484 7115 -----Original Message----- From: Becoming Digital [mailto:[EMAIL PROTECTED] Sent: June 4, 2003 3:35 PM To: [EMAIL PROTECTED] Subject: Re: NEWBIE QUESTION: Copying Databases from local to server I'd suggest using phpMyAdmin on the remote server for your setup. Depending on the application, it might make further transfers easier in the future. Edward Dudlik Becoming Digital www.becomingdigital.com ----- Original Message ----- From: "Creative Solutions New Media" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, 04 June, 2003 00:49 Subject: NEWBIE QUESTION: Copying Databases from local to server Hello, I have several databases currently located on my local machine that I need to copy to a remote server. Con someone explain the process and details of how this is done? Thanks, Tim Winters Manager, Creative Development Sampling Technologies Incorporated (STI) [EMAIL PROTECTED] [EMAIL PROTECTED] W: 902 450 5500 C: 902 430 8498 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
