On Tue, Oct 11, 2011 at 7:08 PM, <[email protected]> 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 _______________________________________________ ILUGC Mailing List: http://www.ae.iitm.ac.in/mailman/listinfo/ilugc
