Hello Mr.Arun Many thanks to you for your excellent tips towards migrating D/B. Migration has been completed. However, I am not able to see the end result from target m/c. (i.e.)MySQL server on RHEL server. It comes out with no 'entry found' message upon query submission through front end. I am using perl-cgi script on the backend for submitting and retrieving data from MySQL D/B. I checked the existence of D/B on target machine but it does not show up 'TABLES' for the exported respective D/Bs(Empty set 0.00 sec) The MySQL command prompt outputs entry not found. Kindly help further.
with thanks s.mahalingam ----- Original Message ----- From: "Arun Venkataswamy" <[email protected]> To: "ILUG-C" <[email protected]> Sent: Tuesday, 11 October, 2011 10:56:16 PM Subject: Re: [Ilugc] guidelines to be followed for exporting MySQL database 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 _______________________________________________ ILUGC Mailing List: http://www.ae.iitm.ac.in/mailman/listinfo/ilugc
