Ensure proper permission for the user to access the database. Run 'show
databases" as root user from mysql console.
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 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" <arun289 at gmail.com>
To: "ILUG-C" <ilugc at ae.iitm.ac.in>
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, <smal at ccmb.res.in> wrote:
I shall appreciate, if anyone can offer guidelines/tutorials to befollowed
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