[Ilugc] guidelines to be followed for exporting MySQL database
- From: arun289@xxxxxxxxx (Arun Venkataswamy)
- Date: Tue, 11 Oct 2011 22:56:16 +0530
On Tue, Oct 11, 2011 at 7:08 PM, <smal at ccmb.res.in> wrote:
I shall appreciate, if anyone can offer guidelines/tutorials to be followed
for migrating/exporting MySQL D/B developed and deployed on MS Windows
platform(DESKTOP) to MySQL server on RHEL 5.5.(configured with
Apache+php+MySQL
MySQL's command line tools are same whether it is used in Windows or Linux.
In the source machine (Windows in your case):
Go the command prompt (Start->Run->Cmd)
*mysqldump* -u *username* -p *databasename* >* backupfile.sql*
Copy the backup file over to the linux machine.
There in a shell:
*mysql* -u *username* -p *databasename* < *backupfile.sql*
make sure that the database 'databasename' exists in the target machine and
is empty.
To create the database in the target machine:
*mysql* -u *username* -p
In the mysql command prompt:
mysql>create database databasename;
mysql>quit
Hope that helps.
Regards,
Arun
Other related posts: