[Ilugc] guidelines to be followed for exporting MySQL database
- From: smal at ccmb.res.in (smal@xxxxxxxxxxx)
- Date: Wed, 12 Oct 2011 15:27:40 +0530 (IST)
----- Original Message -----
From: "Guruprasad" <lgp171188@xxxxxxxxx>
To: "ILUG-C" <ilugc at ae.iitm.ac.in>
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, <smal at ccmb.res.in> 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
Other related posts: