----- Original Message ----- From: "Guruprasad" <[email protected]> To: "ILUG-C" <[email protected]> Sent: Wednesday, 12 October, 2011 1:42:42 PM Subject: Re: [Ilugc] guidelines to be followed for exporting MySQL database
Hi, On Wed, Oct 12, 2011 at 11:49 AM, <[email protected]> wrote: > 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 If you aren't comfortable using the command-line tools, you could use phpMyAdmin to do the export and import. Login into phpMyAdmin, select the database and select 'Export' and export the database in one of the available formats. Then open the phpMyAdmin for the destination database server and create a database. Select that database and using 'Import' import the dumped data from the saved dump into the destination database. Refer - http://www.phpmyadmin.net/documentation/#faq6_4 and http://www.phpmyadmin.net/documentation/#faq6_5 And please follow the mailing list guidelines (http://www.ilugc.in/content/mailinglist-guidelines) and do not top post. Interleaved, trimmed posting is the recommended style. Thanks & Regards, Guruprasad Hi All I owe my sincere thanks & compliments to those who responded to this thread & query as I have successfully ahcieved the result which I was looking for. The mistake was with me only because while importing the sql file to target machine I was using 'mysqldump' command instead of 'mysql'. This was the reason due to whcih there was slight hiccup. Thanks to all. with sincere thanks & regards s.mahalingam _______________________________________________ ILUGC Mailing List: http://www.ae.iitm.ac.in/mailman/listinfo/ilugc _______________________________________________ ILUGC Mailing List: http://www.ae.iitm.ac.in/mailman/listinfo/ilugc
