Re: Cannot complete database transfer
Hello. Have you installed clients programs? One package can contain only server (mysqld), another only client programs (mysql). James Sherwood [EMAIL PROTECTED] wrote: I am trying to transfer a database from one linux box to another, both using redhat. On one I performed a mysqldump and it worked fine. On the other I created the database using a manager and tried the 'mysql username password database filename.sql' command The problem is, I cannot seem to get the box to see the mysql. I found it in init.d I have root access I keep getting 'command not found'. Any ideas would be greatly appreciated James -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Cannot complete database transfer
Did you install MySQL on the other box? It sounds like you took a snapshot of the data but have not installed the executables yet. James Sherwood wrote: I am trying to transfer a database from one linux box to another, both using redhat. On one I performed a mysqldump and it worked fine. On the other I created the database using a manager and tried the 'mysql username password database filename.sql' command The problem is, I cannot seem to get the box to see the mysql. I found it in init.d I have root access I keep getting 'command not found'. Any ideas would be greatly appreciated James -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Cannot complete database transfer
I keep getting 'command not found'. This error indicates that your shell cannot find the mysql file to execute (or that it is not executable for some reason... bad permissions). This can be caused by mysql (client) not being installed or by the client not being on a path that your user can see. more below... Victor Pendleton wrote: Did you install MySQL on the other box? It sounds like you took a snapshot of the data but have not installed the executables yet. James Sherwood wrote: I am trying to transfer a database from one linux box to another, both using redhat. On one I performed a mysqldump and it worked fine. On the other I created the database using a manager and tried the 'mysql username password database filename.sql' command The problem is, I cannot seem to get the box to see the mysql. I found it in init.d The mysql in init.d is a control script that starts and stops the daemon. It is not the mysql client program and mysql mysqld. vi (or whatever your text editor preference may be) the script and look at it. You can find your bin dir somewhere in this file. Once you find it you can see if mysql is in there. I have root access try su - instead of su if that is what you are using for root access. I keep getting 'command not found'. Any ideas would be greatly appreciated James hth, -- Jason McKnight Mgr. Information Services The InSite Group,LLC -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Cannot complete database transfer
It seems like the database installed fine(it is up and running, but I use a manager from a windows box to manipulate it) but maybe the client messed up on install? If so is there a way to just install the mysql client? James - Original Message - From: Jason McKnight [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, December 15, 2004 11:07 AM Subject: Re: Cannot complete database transfer I keep getting 'command not found'. This error indicates that your shell cannot find the mysql file to execute (or that it is not executable for some reason... bad permissions). This can be caused by mysql (client) not being installed or by the client not being on a path that your user can see. more below... Victor Pendleton wrote: Did you install MySQL on the other box? It sounds like you took a snapshot of the data but have not installed the executables yet. James Sherwood wrote: I am trying to transfer a database from one linux box to another, both using redhat. On one I performed a mysqldump and it worked fine. On the other I created the database using a manager and tried the 'mysql username password database filename.sql' command The problem is, I cannot seem to get the box to see the mysql. I found it in init.d The mysql in init.d is a control script that starts and stops the daemon. It is not the mysql client program and mysql mysqld. vi (or whatever your text editor preference may be) the script and look at it. You can find your bin dir somewhere in this file. Once you find it you can see if mysql is in there. I have root access try su - instead of su if that is what you are using for root access. I keep getting 'command not found'. Any ideas would be greatly appreciated James hth, -- Jason McKnight Mgr. Information Services The InSite Group,LLC -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Cannot complete database transfer
Yes, there are other databases on that mysql installation. The only thing is, I recently upgraded it to the latest release of mysql. James - Original Message - From: Victor Pendleton [EMAIL PROTECTED] To: James Sherwood [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Wednesday, December 15, 2004 10:47 AM Subject: Re: Cannot complete database transfer Did you install MySQL on the other box? It sounds like you took a snapshot of the data but have not installed the executables yet. James Sherwood wrote: I am trying to transfer a database from one linux box to another, both using redhat. On one I performed a mysqldump and it worked fine. On the other I created the database using a manager and tried the 'mysql username password database filename.sql' command The problem is, I cannot seem to get the box to see the mysql. I found it in init.d I have root access I keep getting 'command not found'. Any ideas would be greatly appreciated James -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Cannot complete database transfer
I am trying to transfer a database from one linux box to another, both using redhat. On one I performed a mysqldump and it worked fine. On the other I created the database using a manager and tried the 'mysql username password database filename.sql' command The problem is, I cannot seem to get the box to see the mysql. I found it in init.d I have root access I keep getting 'command not found'. Any ideas would be greatly appreciated James -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Cannot complete database transfer
What do you get when you do a `which mysql` from the command line? James Sherwood wrote: Yes, there are other databases on that mysql installation. The only thing is, I recently upgraded it to the latest release of mysql. James - Original Message - From: Victor Pendleton [EMAIL PROTECTED] To: James Sherwood [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Wednesday, December 15, 2004 10:47 AM Subject: Re: Cannot complete database transfer Did you install MySQL on the other box? It sounds like you took a snapshot of the data but have not installed the executables yet. James Sherwood wrote: I am trying to transfer a database from one linux box to another, both using redhat. On one I performed a mysqldump and it worked fine. On the other I created the database using a manager and tried the 'mysql username password database filename.sql' command The problem is, I cannot seem to get the box to see the mysql. I found it in init.d I have root access I keep getting 'command not found'. Any ideas would be greatly appreciated James -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]