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, <[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 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 > -- Thanks and Regards, Senthil http://twitter.com/senthiln _______________________________________________ ILUGC Mailing List: http://www.ae.iitm.ac.in/mailman/listinfo/ilugc
