Re: Urgent please..
Thank you very much..excellent support - Original Message - From: "Logan, David (SST - Adelaide)" <[EMAIL PROTECTED]> To: "Renish" <[EMAIL PROTECTED]> Cc: ; "Joshua J. Kugler" <[EMAIL PROTECTED]> Sent: Thursday, November 16, 2006 12:16 PM Subject: RE: Urgent please.. Hi Renish, Perhaps these might be a more appropriate forum and also get you the result you need. This being a database list (I'm sure there are php experts on here) is probably not quite the right place to be asking. One of the php lists may produce a more relevant response. http://www.php.net/mailing-lists.php Regards --- ** _/ ** David Logan *** _/ *** ITO Delivery Specialist - Database *_/* Hewlett-Packard Australia Ltd _/_/_/ _/_/_/ E-Mail: [EMAIL PROTECTED] _/ _/ _/ _/ Desk: +61 8 8408 4273 _/ _/ _/_/_/ Mobile: +61 417 268 665 *_/ ** ** _/ Postal: 148 Frome Street, _/ ** Adelaide SA 5001 Australia invent --- -Original Message- From: Renish [mailto:[EMAIL PROTECTED] Sent: Thursday, 16 November 2006 2:38 PM To: Joshua J. Kugler Cc: mysql@lists.mysql.com Subject: Re: Urgent please.. Ocourse i read the manual . I was unable to do so..ie the reason I asked...I also knew this location mysql@lists.mysql.com - Original Message - From: "Joshua J. Kugler" <[EMAIL PROTECTED]> To: Cc: "Renish" <[EMAIL PROTECTED]> Sent: Thursday, November 16, 2006 11:20 AM Subject: Re: Urgent please.. On Wednesday 15 November 2006 18:14, Renish wrote: Can anyone tell me..how to install PHP php-5.2.0-Win32 . i click on php.exe and nothing seems to happen. I have intalled 1) webserver-Apache2 2) MySql-41.1 Please read the documentation before asking questions such as these. Thanks. http://www.php.net/manual/en/install.windows.php j -- Joshua Kugler Lead System Admin -- Senior Programmer http://www.eeinternet.com PGP Key: http://pgp.mit.edu/ ID 0xDB26D7CE PO Box 80086 -- Fairbanks, AK 99708 -- Ph: 907-456-5581 Fax: 907-456-3111 -- 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: Urgent please..
Hi Renish, Perhaps these might be a more appropriate forum and also get you the result you need. This being a database list (I'm sure there are php experts on here) is probably not quite the right place to be asking. One of the php lists may produce a more relevant response. http://www.php.net/mailing-lists.php Regards --- ** _/ ** David Logan *** _/ *** ITO Delivery Specialist - Database *_/* Hewlett-Packard Australia Ltd _/_/_/ _/_/_/ E-Mail: [EMAIL PROTECTED] _/ _/ _/ _/ Desk: +61 8 8408 4273 _/ _/ _/_/_/ Mobile: +61 417 268 665 *_/ ** ** _/ Postal: 148 Frome Street, _/ ** Adelaide SA 5001 Australia invent --- -Original Message- From: Renish [mailto:[EMAIL PROTECTED] Sent: Thursday, 16 November 2006 2:38 PM To: Joshua J. Kugler Cc: mysql@lists.mysql.com Subject: Re: Urgent please.. Ocourse i read the manual . I was unable to do so..ie the reason I asked...I also knew this location mysql@lists.mysql.com - Original Message - From: "Joshua J. Kugler" <[EMAIL PROTECTED]> To: Cc: "Renish" <[EMAIL PROTECTED]> Sent: Thursday, November 16, 2006 11:20 AM Subject: Re: Urgent please.. > On Wednesday 15 November 2006 18:14, Renish wrote: >> Can anyone tell me..how to install PHP php-5.2.0-Win32 . i click on >> php.exe and nothing seems to happen. >> I have intalled >> 1) webserver-Apache2 >> 2) MySql-41.1 > > Please read the documentation before asking questions such as these. > Thanks. > > http://www.php.net/manual/en/install.windows.php > > j > > -- > Joshua Kugler > Lead System Admin -- Senior Programmer > http://www.eeinternet.com > PGP Key: http://pgp.mit.edu/ ID 0xDB26D7CE > PO Box 80086 -- Fairbanks, AK 99708 -- Ph: 907-456-5581 Fax: 907-456-3111 -- 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: Urgent please..
Ocourse i read the manual . I was unable to do so..ie the reason I asked...I also knew this location mysql@lists.mysql.com - Original Message - From: "Joshua J. Kugler" <[EMAIL PROTECTED]> To: Cc: "Renish" <[EMAIL PROTECTED]> Sent: Thursday, November 16, 2006 11:20 AM Subject: Re: Urgent please.. On Wednesday 15 November 2006 18:14, Renish wrote: Can anyone tell me..how to install PHP php-5.2.0-Win32 . i click on php.exe and nothing seems to happen. I have intalled 1) webserver-Apache2 2) MySql-41.1 Please read the documentation before asking questions such as these. Thanks. http://www.php.net/manual/en/install.windows.php j -- Joshua Kugler Lead System Admin -- Senior Programmer http://www.eeinternet.com PGP Key: http://pgp.mit.edu/ ID 0xDB26D7CE PO Box 80086 -- Fairbanks, AK 99708 -- Ph: 907-456-5581 Fax: 907-456-3111 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Urgent please..
Try http://www.php.net/manual/en/install.windows.php --- ** _/ ** David Logan *** _/ *** ITO Delivery Specialist - Database *_/* Hewlett-Packard Australia Ltd _/_/_/ _/_/_/ E-Mail: [EMAIL PROTECTED] _/ _/ _/ _/ Desk: +61 8 8408 4273 _/ _/ _/_/_/ Mobile: +61 417 268 665 *_/ ** ** _/ Postal: 148 Frome Street, _/ ** Adelaide SA 5001 Australia invent --- -Original Message- From: Renish [mailto:[EMAIL PROTECTED] Sent: Thursday, 16 November 2006 1:44 PM To: mysql@lists.mysql.com Subject: Urgent please.. All, Can anyone tell me..how to install PHP php-5.2.0-Win32 . i click on php.exe and nothing seems to happen. I have intalled 1) webserver-Apache2 2) MySql-41.1 I want to use PHP as sever side scripting. Cheers, Renish. -- 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: Urgent please..
On Wednesday 15 November 2006 18:14, Renish wrote: > Can anyone tell me..how to install PHP php-5.2.0-Win32 . i click on > php.exe and nothing seems to happen. > I have intalled > 1) webserver-Apache2 > 2) MySql-41.1 Please read the documentation before asking questions such as these. Thanks. http://www.php.net/manual/en/install.windows.php j -- Joshua Kugler Lead System Admin -- Senior Programmer http://www.eeinternet.com PGP Key: http://pgp.mit.edu/ ID 0xDB26D7CE PO Box 80086 -- Fairbanks, AK 99708 -- Ph: 907-456-5581 Fax: 907-456-3111 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: urgent : PLEASE HELP - problems with back up and restore
Hi, Thanks Again. You are really helping me Well it get a lot of "query ok, 0 rows affected <0.00 sec>" And one like this : query ok, 2 rows affected <0.01 sec> Records: 2 Duplicates: 0 Warnings: 0 But it look like everything is in the Database now ? What is this "Source" Command ? Another thing I noticed is that My Original databes my Sp's Got "Delimiter $$" But on the backup file it replaced with ;; Barak _ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, November 24, 2005 7:21 AM To: Barak Mery Cc: mysql@lists.mysql.com Subject: RE: urgent : PLEASE HELP - problems with back up and restore I saw both views and stored procedures in the dump file. What error do you get if you process the script with the "source" command within the MySQL CLI? mysql -uroot -pmypass (login welcome) mysql> CREATE DATABASE IF NOT EXISTS bcm; mysql> USE bcm; mysql> source myback1.sql There is another option to drop/create the database. Your dump didn't have that so you need to do it manually in order to restore it. Shawn Green Database Administrator Unimin Corporation - Spruce Pine "Barak Mery" <[EMAIL PROTECTED]> wrote on 11/23/2005 07:18:02 PM: > Wel I read the manual but didn't find something that I really need to add > I suspect it is something with the script itself. > > Now I'm using > mysqldump -uroot -pmypass --routines -q -x bcm>myback1.sql > > but after i run > mysqldump -uroot -pmypass --routines bcm>myback1.sql > > it now restore the tables but not the views or sp's > > here is the backup file > > thanks > Barak > > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: Wednesday, November 23, 2005 9:30 PM > To: Barak Mery > Cc: mysql@lists.mysql.com > Subject: RE: urgent : PLEASE HELP - problems with back up and restore > > > There's a new option added in 5.0.13: > > -R (--routines) > > It's designed designed specifically to dump SPROCs and FUNCTIONs. I > thought it would have been turned on by default but I guess it > wasn't. Add that to the list of options and check your dump results > again. I refer you again to the manual for additional warnings and cautions. > > http://dev.mysql.com/doc/refman/5.0/en/mysqldump.html > > Shawn Green > Database Administrator > Unimin Corporation - Spruce Pine > > > > "Barak Mery" <[EMAIL PROTECTED]> wrote on 11/23/2005 02:23:42 PM: > > > Well Shawn, > > > > First of thanks for the quick result. > > > > I tried your suggestion but it didn't help no sp and no restore. > > > > It only shrinked the backup file (by deleting the cr). > > > > Is there any log file where I can trace that kind of erros ? > > > > Barak > > > > > > > > > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > > Sent: Wednesday, November 23, 2005 9:07 PM > > To: Barak Mery > > Cc: mysql@lists.mysql.com > > Subject: Re: urgent : PLEASE HELP - problems with back up and restore > > > > > > > > "Barak Mery" <[EMAIL PROTECTED]> wrote on 11/23/2005 01:51:37 PM: > > > > > Hi, > > > > > > > > > > > > I'm really desperate on this on. > > > > > > After struggling with some really weird bugs I finally finished > my project. > > > > > > > > > > > > Buut I can't perform a good backup and restore. > > > > > > > > > > > > I'm using : > > > > > > MySql 5.0.16-nt (essentials version) > > > > > > Windows xp > > > > > > The DB contains tables, vw's and sp's. > > > > > > It is a very small one and at the moment I don't have any data inside. > > > > > > The whole backup file size is 100Kb. > > > > > > > > > > > > 1. I backed up my db using mysql administrator. > > > It created a back up file with all tables, views and sp's, but > when I tried > > > a restore it got errors like. > > > "Could not handle this statement etc. > > > > > > > > > 2. I tried : mysqldump -uroot -pmypassword dbname > backup.sql > > > And then mysqldump -uroot -pmypassword newDbName < backup.sql > > > I didn't get any error. > > > The shell printed to the screen the backup file completely only > without the > >
RE: urgent : PLEASE HELP - problems with back up and restore
I saw both views and stored procedures in the dump file. What error do you get if you process the script with the "source" command within the MySQL CLI? mysql -uroot -pmypass (login welcome) mysql> CREATE DATABASE IF NOT EXISTS bcm; mysql> USE bcm; mysql> source myback1.sql There is another option to drop/create the database. Your dump didn't have that so you need to do it manually in order to restore it. Shawn Green Database Administrator Unimin Corporation - Spruce Pine "Barak Mery" <[EMAIL PROTECTED]> wrote on 11/23/2005 07:18:02 PM: > Wel I read the manual but didn’t find something that I really need to add > I suspect it is something with the script itself. > > Now I’m using > mysqldump -uroot -pmypass --routines -q -x bcm>myback1.sql > > but after i run > mysqldump -uroot -pmypass --routines bcm>myback1.sql > > it now restore the tables but not the views or sp’s > > here is the backup file > > thanks > Barak > > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: Wednesday, November 23, 2005 9:30 PM > To: Barak Mery > Cc: mysql@lists.mysql.com > Subject: RE: urgent : PLEASE HELP - problems with back up and restore > > > There's a new option added in 5.0.13: > > -R (--routines) > > It's designed designed specifically to dump SPROCs and FUNCTIONs. I > thought it would have been turned on by default but I guess it > wasn't. Add that to the list of options and check your dump results > again. I refer you again to the manual for additional warnings and cautions. > > http://dev.mysql.com/doc/refman/5.0/en/mysqldump.html > > Shawn Green > Database Administrator > Unimin Corporation - Spruce Pine > > > > "Barak Mery" <[EMAIL PROTECTED]> wrote on 11/23/2005 02:23:42 PM: > > > Well Shawn, > > > > First of thanks for the quick result. > > > > I tried your suggestion but it didn’t help no sp and no restore. > > > > It only shrinked the backup file (by deleting the cr). > > > > Is there any log file where I can trace that kind of erros ? > > > > Barak > > > > > > > > > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > > Sent: Wednesday, November 23, 2005 9:07 PM > > To: Barak Mery > > Cc: mysql@lists.mysql.com > > Subject: Re: urgent : PLEASE HELP - problems with back up and restore > > > > > > > > "Barak Mery" <[EMAIL PROTECTED]> wrote on 11/23/2005 01:51:37 PM: > > > > > Hi, > > > > > > > > > > > > I'm really desperate on this on. > > > > > > After struggling with some really weird bugs I finally finished > my project. > > > > > > > > > > > > Buut I can't perform a good backup and restore. > > > > > > > > > > > > I'm using : > > > > > > MySql 5.0.16-nt (essentials version) > > > > > > Windows xp > > > > > > The DB contains tables, vw's and sp's. > > > > > > It is a very small one and at the moment I don't have any data inside. > > > > > > The whole backup file size is 100Kb. > > > > > > > > > > > > 1. I backed up my db using mysql administrator. > > > It created a back up file with all tables, views and sp's, but > when I tried > > > a restore it got errors like. > > > "Could not handle this statement etc. > > > > > > > > > 2. I tried : mysqldump -uroot -pmypassword dbname > backup.sql > > > And then mysqldump -uroot -pmypassword newDbName < backup.sql > > > I didn't get any error. > > > The shell printed to the screen the backup file completely only > without the > > > table script part. > > > > > > It Created a backup file only for the tables (why ? a minute agoI did the > > > backup with the same tool). > > > But after restoring, the new db was still empty. > > > > > > > > > 3. I tried to restore with mysql > -uroot -pmypassword newDbName < > > > backup.sql > > > But I got the same results. > > > > > > > > > > > > > > > > > > It should be a very simple and basic issue. > > > Why everything is so hard with mysql ? > > > > > > > > > > > > Is there any really good and quick forum for mySql ? I posted some new > > > thread i
RE: urgent : PLEASE HELP - problems with back up and restore
Thanks Marko :) -Original Message- From: Marko Knezevic [mailto:[EMAIL PROTECTED] Sent: Thursday, November 24, 2005 12:29 AM To: MySQL list Subject: Re: urgent : PLEASE HELP - problems with back up and restore Dear Barak, Save yourself year or two of your life and try using MySQL Front not that command line tools. Its really nice tool for handling MySQL databases Regards Marko -- 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: urgent : PLEASE HELP - problems with back up and restore
Thanks again, I will try this and read the manual again. _ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 23, 2005 9:30 PM To: Barak Mery Cc: mysql@lists.mysql.com Subject: RE: urgent : PLEASE HELP - problems with back up and restore There's a new option added in 5.0.13: -R (--routines) It's designed designed specifically to dump SPROCs and FUNCTIONs. I thought it would have been turned on by default but I guess it wasn't. Add that to the list of options and check your dump results again. I refer you again to the manual for additional warnings and cautions. http://dev.mysql.com/doc/refman/5.0/en/mysqldump.html Shawn Green Database Administrator Unimin Corporation - Spruce Pine "Barak Mery" <[EMAIL PROTECTED]> wrote on 11/23/2005 02:23:42 PM: > Well Shawn, > > First of thanks for the quick result. > > I tried your suggestion but it didn't help no sp and no restore. > > It only shrinked the backup file (by deleting the cr). > > Is there any log file where I can trace that kind of erros ? > > Barak > > > > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: Wednesday, November 23, 2005 9:07 PM > To: Barak Mery > Cc: mysql@lists.mysql.com > Subject: Re: urgent : PLEASE HELP - problems with back up and restore > > > > "Barak Mery" <[EMAIL PROTECTED]> wrote on 11/23/2005 01:51:37 PM: > > > Hi, > > > > > > > > I'm really desperate on this on. > > > > After struggling with some really weird bugs I finally finished my project. > > > > > > > > Buut I can't perform a good backup and restore. > > > > > > > > I'm using : > > > > MySql 5.0.16-nt (essentials version) > > > > Windows xp > > > > The DB contains tables, vw's and sp's. > > > > It is a very small one and at the moment I don't have any data inside. > > > > The whole backup file size is 100Kb. > > > > > > > > 1. I backed up my db using mysql administrator. > > It created a back up file with all tables, views and sp's, but when I tried > > a restore it got errors like. > > "Could not handle this statement etc. > > > > > > 2. I tried : mysqldump -uroot -pmypassword dbname > backup.sql > > And then mysqldump -uroot -pmypassword newDbName < backup.sql > > I didn't get any error. > > The shell printed to the screen the backup file completely only without the > > table script part. > > > > It Created a backup file only for the tables (why ? a minute ago I did the > > backup with the same tool). > > But after restoring, the new db was still empty. > > > > > > 3. I tried to restore with mysql > -uroot -pmypassword newDbName < > > backup.sql > > But I got the same results. > > > > > > > > > > > > It should be a very simple and basic issue. > > Why everything is so hard with mysql ? > > > > > > > > Is there any really good and quick forum for mySql ? I posted some new > > thread in mysql.com at the past few days but never got answered. > > > > > > > > Is it just me or that's the life on the mysql planet ? > > > > > > > > I now try this mailing-list. I hope you can help me. > > > > > > > > Thanks in advance > > > > Barak > > You are in luck as the mailing list is quite active. > > Look at your actual dump file. It is simply a SQL script that will > create all of the "elements" of the database and populate them with > data (if you had any). My suspicion is that you have something that > isn't quoted that needed to be. > > mysqldump has several options. You can see them with the command: > > mysqldump --help > > -or- refer to the manual > > http://dev.mysql.com/doc/refman/5.0/en/mysqldump.html > > try dumping your database again, this time use the -r= and -Q > options. That does two things: > > a) it avoids adding CR characters at the end of every line > b) it puts backticks around EVERYTHING that needs them (table names, > column names, etc) > > > mysqldump -uroot -pmypassword -r backup.sql -Q dbname > > Shawn Green > Database Administrator > Unimin Corporation - Spruce Pine
RE: urgent : PLEASE HELP - problems with back up and restore
There's a new option added in 5.0.13: -R (--routines) It's designed designed specifically to dump SPROCs and FUNCTIONs. I thought it would have been turned on by default but I guess it wasn't. Add that to the list of options and check your dump results again. I refer you again to the manual for additional warnings and cautions. http://dev.mysql.com/doc/refman/5.0/en/mysqldump.html Shawn Green Database Administrator Unimin Corporation - Spruce Pine "Barak Mery" <[EMAIL PROTECTED]> wrote on 11/23/2005 02:23:42 PM: > Well Shawn, > > First of thanks for the quick result. > > I tried your suggestion but it didn’t help no sp and no restore. > > It only shrinked the backup file (by deleting the cr). > > Is there any log file where I can trace that kind of erros ? > > Barak > > > > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: Wednesday, November 23, 2005 9:07 PM > To: Barak Mery > Cc: mysql@lists.mysql.com > Subject: Re: urgent : PLEASE HELP - problems with back up and restore > > > > "Barak Mery" <[EMAIL PROTECTED]> wrote on 11/23/2005 01:51:37 PM: > > > Hi, > > > > > > > > I'm really desperate on this on. > > > > After struggling with some really weird bugs I finally finished my project. > > > > > > > > Buut I can't perform a good backup and restore. > > > > > > > > I'm using : > > > > MySql 5.0.16-nt (essentials version) > > > > Windows xp > > > > The DB contains tables, vw's and sp's. > > > > It is a very small one and at the moment I don't have any data inside. > > > > The whole backup file size is 100Kb. > > > > > > > > 1. I backed up my db using mysql administrator. > > It created a back up file with all tables, views and sp's, but when I tried > > a restore it got errors like. > > "Could not handle this statement etc. > > > > > > 2. I tried : mysqldump -uroot -pmypassword dbname > backup.sql > > And then mysqldump -uroot -pmypassword newDbName < backup.sql > > I didn't get any error. > > The shell printed to the screen the backup file completely only without the > > table script part. > > > > It Created a backup file only for the tables (why ? a minute ago I did the > > backup with the same tool). > > But after restoring, the new db was still empty. > > > > > > 3. I tried to restore with mysql > -uroot -pmypassword newDbName < > > backup.sql > > But I got the same results. > > > > > > > > > > > > It should be a very simple and basic issue. > > Why everything is so hard with mysql ? > > > > > > > > Is there any really good and quick forum for mySql ? I posted some new > > thread in mysql.com at the past few days but never got answered. > > > > > > > > Is it just me or that's the life on the mysql planet ? > > > > > > > > I now try this mailing-list. I hope you can help me. > > > > > > > > Thanks in advance > > > > Barak > > You are in luck as the mailing list is quite active. > > Look at your actual dump file. It is simply a SQL script that will > create all of the "elements" of the database and populate them with > data (if you had any). My suspicion is that you have something that > isn't quoted that needed to be. > > mysqldump has several options. You can see them with the command: > > mysqldump --help > > -or- refer to the manual > > http://dev.mysql.com/doc/refman/5.0/en/mysqldump.html > > try dumping your database again, this time use the -r= and -Q > options. That does two things: > > a) it avoids adding CR characters at the end of every line > b) it puts backticks around EVERYTHING that needs them (table names, > column names, etc) > > > mysqldump -uroot -pmypassword -r backup.sql -Q dbname > > Shawn Green > Database Administrator > Unimin Corporation - Spruce Pine
RE: urgent : PLEASE HELP - problems with back up and restore
Well Shawn, First of thanks for the quick result. I tried your suggestion but it didn't help no sp and no restore. It only shrinked the backup file (by deleting the cr). Is there any log file where I can trace that kind of erros ? Barak _ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 23, 2005 9:07 PM To: Barak Mery Cc: mysql@lists.mysql.com Subject: Re: urgent : PLEASE HELP - problems with back up and restore "Barak Mery" <[EMAIL PROTECTED]> wrote on 11/23/2005 01:51:37 PM: > Hi, > > > > I'm really desperate on this on. > > After struggling with some really weird bugs I finally finished my project. > > > > Buut I can't perform a good backup and restore. > > > > I'm using : > > MySql 5.0.16-nt (essentials version) > > Windows xp > > The DB contains tables, vw's and sp's. > > It is a very small one and at the moment I don't have any data inside. > > The whole backup file size is 100Kb. > > > > 1. I backed up my db using mysql administrator. > It created a back up file with all tables, views and sp's, but when I tried > a restore it got errors like. > "Could not handle this statement etc. > > > 2. I tried : mysqldump -uroot -pmypassword dbname > backup.sql > And then mysqldump -uroot -pmypassword newDbName < backup.sql > I didn't get any error. > The shell printed to the screen the backup file completely only without the > table script part. > > It Created a backup file only for the tables (why ? a minute ago I did the > backup with the same tool). > But after restoring, the new db was still empty. > > > 3. I tried to restore with mysql > -uroot -pmypassword newDbName < > backup.sql > But I got the same results. > > > > > > It should be a very simple and basic issue. > Why everything is so hard with mysql ? > > > > Is there any really good and quick forum for mySql ? I posted some new > thread in mysql.com at the past few days but never got answered. > > > > Is it just me or that's the life on the mysql planet ? > > > > I now try this mailing-list. I hope you can help me. > > > > Thanks in advance > > Barak You are in luck as the mailing list is quite active. Look at your actual dump file. It is simply a SQL script that will create all of the "elements" of the database and populate them with data (if you had any). My suspicion is that you have something that isn't quoted that needed to be. mysqldump has several options. You can see them with the command: mysqldump --help -or- refer to the manual http://dev.mysql.com/doc/refman/5.0/en/mysqldump.html try dumping your database again, this time use the -r= and -Q options. That does two things: a) it avoids adding CR characters at the end of every line b) it puts backticks around EVERYTHING that needs them (table names, column names, etc) mysqldump -uroot -pmypassword -r backup.sql -Q dbname Shawn Green Database Administrator Unimin Corporation - Spruce Pine
Re: urgent : PLEASE HELP - problems with back up and restore
"Barak Mery" <[EMAIL PROTECTED]> wrote on 11/23/2005 01:51:37 PM: > Hi, > > > > I'm really desperate on this on. > > After struggling with some really weird bugs I finally finished my project. > > > > Buut I can't perform a good backup and restore. > > > > I'm using : > > MySql 5.0.16-nt (essentials version) > > Windows xp > > The DB contains tables, vw's and sp's. > > It is a very small one and at the moment I don't have any data inside. > > The whole backup file size is 100Kb. > > > > 1. I backed up my db using mysql administrator. > It created a back up file with all tables, views and sp's, but when I tried > a restore it got errors like. > "Could not handle this statement etc. > > > 2. I tried : mysqldump -uroot -pmypassword dbname > backup.sql > And then mysqldump -uroot -pmypassword newDbName < backup.sql > I didn't get any error. > The shell printed to the screen the backup file completely only without the > table script part. > > It Created a backup file only for the tables (why ? a minute ago I did the > backup with the same tool). > But after restoring, the new db was still empty. > > > 3. I tried to restore with mysql > -uroot -pmypassword newDbName < > backup.sql > But I got the same results. > > > > > > It should be a very simple and basic issue. > Why everything is so hard with mysql ? > > > > Is there any really good and quick forum for mySql ? I posted some new > thread in mysql.com at the past few days but never got answered. > > > > Is it just me or that's the life on the mysql planet ? > > > > I now try this mailing-list. I hope you can help me. > > > > Thanks in advance > > Barak You are in luck as the mailing list is quite active. Look at your actual dump file. It is simply a SQL script that will create all of the "elements" of the database and populate them with data (if you had any). My suspicion is that you have something that isn't quoted that needed to be. mysqldump has several options. You can see them with the command: mysqldump --help -or- refer to the manual http://dev.mysql.com/doc/refman/5.0/en/mysqldump.html try dumping your database again, this time use the -r= and -Q options. That does two things: a) it avoids adding CR characters at the end of every line b) it puts backticks around EVERYTHING that needs them (table names, column names, etc) mysqldump -uroot -pmypassword -r backup.sql -Q dbname Shawn Green Database Administrator Unimin Corporation - Spruce Pine
Re: Urgent: Please look at this error
It looks like you don't have a path to that library. Once you find the true location of libpthread.so, add that directory path to the file /etc/ld.conf. After that is done, run: ldconfig -v as root and try again. On Wed, 2002-03-20 at 09:13, Amrita Basu wrote: > Hi, I am using Redhat 6.2 kernel 2.2.20 and am getting > this error below. I know that these paths are > incorrect , should be /jive/usr/biosym/235 instead > of /usr/biosym... where do I change this? Which file? > Sorry if this is obvious, but I am new to mysql. > Thanks, > Amrita > > unknown user id: mysql > Starting mysqld daemon with databases from > /oscar2/mysql/mysql-3.23.47-sgi-irix6.5-mips/data > > 4673:/oscar2/mysql/mysql-3.23.47-sgi-irix6.5-mips/bin/mysqld: > rld: > Fatal Error: Cannot Successfully map soname > 'libpthread.so' under any of > the filenames > >/usr/biosym/235/irix51r4/biosymso/libpthread.so:/usr/lib32/libpthread.so:/usr/lib32/internal/libpthread.so:/lib32/libpthread.so:/opt/lib32/libpthread.so:/usr/biosym/235/irix51r4/biosymso/libpthread.so.1:/usr/lib32/libpthread.so.1:/usr/lib32/internal/libpthread.so.1:/lib32/libpthread.so.1:/opt/lib32/libpthread.so.1: > > 020319 18:46:10 mysqld ended > > > __ > Do You Yahoo!? > Yahoo! Sports - live college hoops coverage > http://sports.yahoo.com/ > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php