csland.com

Independant Computer Consultant

Software Consulting, Development, Strategy, and Programming
Home >  How to move MySQL database to other server?

How to move MySQL database to other server?

01/10/2010
6094 hits
      1) Use phpAdmin:
      phpMyAdmin is a free software tool written in PHP intended to handle the administration of MySQL over the World Wide Web.
      
      2) Use command line comands mysqldump and mysql:
       a) mysqldump -uuser_id -p db_name >db_file, where user_id is the user name for accessing database db_name, and db_file is the file name will hold the structure and data from the database.
       b) in the new database server, do this:
       mysql -uuser_id -p db_name <db_file
      Before doing this, make the you have created a new database named db_name with the user_id and password.

[01/10/2010, 09:33]
CSLand.Com © 1996-2009. All Rights Reserved