Re: mysql dump global read lock
Artem, You have --add-locks listed which will run LOCK TABLES prior to each table dump. --single-transaction is for InnoDB tables and ensures that they are copied in a consistent state. I hope this helps! On Thu, Dec 17, 2015 at 4:24 PM, Artem Kuchin wrote: > Hello! > > Hereis my mysqldump command line > > mysqldump -u root --events --complete-insert --skip-opt > --single-transaction --add-drop-table --add-locks --create-options > --disable-keys -- > extended-insert --quick --set-charset --routines --triggers --hex-blob > DB_NAME > > But i see tons of Waiting for global read lock > in show processlist for many tables in many different databases for all > modification queries and locks > > Why? As i understood --skip-opt --single-transaction must disable global > read lock > > > mysql version > Server version: 5.6.27-log Source distribution > > Artem > > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/mysql > >
RE: mysql dump problems, no data dumped
This is a known bug, Ive installed MySQL 4 client binaries as a work around... _ From: Andy Smith [mailto:[EMAIL PROTECTED] Sent: 2008-10-30 18:26 To: 'mysql@lists.mysql.com' Subject: mysql dump problems, no data dumped Im having an issue using mysqldump to dump a DB from comercial app which includes mysql 4.0.18-pro. It doesnt however include mysql dump for online backups so Im using the one installed by default in my linux dist which as you can see below is version 10.11. My problem is that the dump is exiting with exist status 0 but Im not getting any of the data dumped. The WHOLE dump is shown in text below:
RE: mysql dump problems, no data dumped
Hi Rick, ok sorry, heres a bit more detail, and I see some more useful stuff I didn't see before too (I still duno whats wrong but guess will be helpful to those more knowledgeable!). I believe its using InnoDB for the tables, previously I was seeing an error 24 which from digging around can be related to too many open files, so I then tried with single transaction mode and get the successful backup exit status, but in verbose mode I see that there are obvious issues. mysqldump -v --single-transaction --socket=/usr/AdventNet/ME/OpManager/mysql/mysql.socket OpManagerDB -- Connecting to localhost... -- MySQL dump 10.11 -- -- Host: localhostDatabase: OpManagerDB -- -- -- Server version 4.0.18-pro /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; /*!40103 SET TIME_ZONE='+00:00' */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; -- Retrieving table structure for table ADGRAPHS... -- Skipping dump data for table 'ADGRAPHS', it has no fields -- Retrieving table structure for table ADMonitorRuleList... -- Skipping dump data for table 'ADMonitorRuleList', it has no fields -- Retrieving table structure for table ADServiceRuleList... -- Skipping dump data for table 'ADServiceRuleList', it has no fields -- Retrieving table structure for table ADServicesDefinition... -- Skipping dump data for table 'ADServicesDefinition', it has no fields -- Retrieving table structure for table ADWMIPolledData... -- Skipping dump data for table 'ADWMIPolledData', it has no fields . . -- Disconnecting from localhost... /*!40103 SET [EMAIL PROTECTED] */; /*!40101 SET [EMAIL PROTECTED] */; /*!40014 SET [EMAIL PROTECTED] */; /*!40014 SET [EMAIL PROTECTED] */; /*!40111 SET [EMAIL PROTECTED] */; -- Dump completed on 2008-10-30 19:06:25 Without single transaction I get this: mysqldump --socket=/usr/AdventNet/ME/OpManager/mysql/mysql.socket OpManagerDB -- MySQL dump 10.11 -- -- Host: localhostDatabase: OpManagerDB -- -- -- Server version 4.0.18-pro /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; /*!40103 SET TIME_ZONE='+00:00' */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; mysqldump: Got error: 1017: Can't find file: './OpManagerDB/WANIntfTypes.frm' (errno: 24) when using LOCK TABLES This file mentioned does exist in the location where all the datafiles for the OpManagerDB DB are stored: file WANIntfTypes.frm WANIntfTypes.frm: MySQL table definition file Version 7 Thanks, Andy. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysql dump problems, no data dumped
what command are you using to do the dump? I mean the entire command, including all the options. On Thu, Oct 30, 2008 at 12:25 PM, Andy Smith <[EMAIL PROTECTED]> wrote: > Hi, > > Im having an issue using mysqldump to dump a DB from comercial app which > includes mysql 4.0.18-pro. It doesnt however include mysql dump for online > backups so Im using the one installed by default in my linux dist which as > you can see below is version 10.11. My problem is that the dump is exiting > with exist status 0 but Im not getting any of the data dumped. The WHOLE > dump is shown in text below: > > -- MySQL dump 10.11 > -- > -- Host: localhostDatabase: OpManagerDB > -- -- > -- Server version 4.0.18-pro > /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; > /*!40103 SET TIME_ZONE='+00:00' */; > /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; > /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, > FOREIGN_KEY_CHECKS=0 > */; > /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; > /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; > /*!40103 SET [EMAIL PROTECTED] */; > > /*!40101 SET [EMAIL PROTECTED] */; > /*!40014 SET [EMAIL PROTECTED] */; > /*!40014 SET [EMAIL PROTECTED] */; > /*!40111 SET [EMAIL PROTECTED] */; > > -- Dump completed on 2008-10-27 13:50:53 > > Can anyone help me? I need to work out why no data is written, > > thanks Andy. > > -- Jim Lyons Web developer / Database administrator http://www.weblyons.com
Re: mysql dump problems, no data dumped
Hi,andy. Can you show me the details about the options of mysqldump to be used ? On Fri, Oct 31, 2008 at 1:25 AM, Andy Smith <[EMAIL PROTECTED]> wrote: > Hi, > > Im having an issue using mysqldump to dump a DB from comercial app which > includes mysql 4.0.18-pro. It doesnt however include mysql dump for online > backups so Im using the one installed by default in my linux dist which as > you can see below is version 10.11. My problem is that the dump is exiting > with exist status 0 but Im not getting any of the data dumped. The WHOLE > dump is shown in text below: > > -- MySQL dump 10.11 > -- > -- Host: localhostDatabase: OpManagerDB > -- -- > -- Server version 4.0.18-pro > /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; > /*!40103 SET TIME_ZONE='+00:00' */; > /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; > /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, > FOREIGN_KEY_CHECKS=0 > */; > /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; > /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; > /*!40103 SET [EMAIL PROTECTED] */; > > /*!40101 SET [EMAIL PROTECTED] */; > /*!40014 SET [EMAIL PROTECTED] */; > /*!40014 SET [EMAIL PROTECTED] */; > /*!40111 SET [EMAIL PROTECTED] */; > > -- Dump completed on 2008-10-27 13:50:53 > > Can anyone help me? I need to work out why no data is written, > > thanks Andy. > > -- I'm a MySQL DBA in china. More about me just visit here: http://yueliangdao0608.cublog.cn
Re: mysql dump
from the mydump help screen: $ mysqldump --help mysqldump Ver 10.10 Distrib 5.0.22, for redhat-linux-gnu (x86_64) ... with all databases selected. --add-drop-database Add a 'DROP DATABASE' before each create. --add-drop-tableAdd a 'drop table' before each create. ... --create-optionsInclude all MySQL specific create options. -B, --databases To dump several databases. Note the difference in usage; In this case no tables are given. All name arguments are regarded as databasenames. 'USE db_name;' will be included in the output. - michael On Dec 11, 2007 2:04 PM, Naufal Sheikh <[EMAIL PROTECTED]> wrote: > Hello every one, > > I have two questions actually. If there is a database server with couple of > databases, and we only want to take the dump of few of them, can we specify > a list of those on either mysqldump or mysql prompt ( for any other purpose > ).or we have to run the mysqldump command seperately for every database. > > e.g. mysqldump --database1 > database1.sql > mysqldump --database2 > database2.sql > > or mysqldump --database1 --database2 > database.sql > > Second, when I am importing a dump file into another server, if that server > already has thate database, it gives me an error of saying that the > table/column already exists. Is there any switch to over ride that. > > > > I'll appreciate if some can please help me on above! > > Thanks > Naufal > -- - michael dykman - [EMAIL PROTECTED] - All models are wrong. Some models are useful. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysql dump
Thank you so much! On Nov 13, 2007 2:40 PM, Craig Huffstetler <[EMAIL PROTECTED]> wrote: > No, but a table lock or two may be expected. This is to PREVENT data loss > (which you were also worried about). > > The mysqldump process will most likely be quick and painless (quick being a > relative term, depending on the amount of data in your database(s)). > > Craig > > > > On Nov 13, 2007 2:35 PM, Naufal Sheikh <[EMAIL PROTECTED]> wrote: > > > > > > > > So is it safe to take the dump while database is running. I mean is > > there any loss of data expected because of taking dump while a > > database is running. > > > > > > > > > > > > > > > > On Nov 13, 2007 2:26 PM, Michael Dykman < [EMAIL PROTECTED]> wrote: > > > > > > On Nov 13, 2007 2:11 PM, Naufal Sheikh <[EMAIL PROTECTED]> wrote: > > > > Hello everyone, > > > > > > > > Few conceptual questions which I can't understand. If any one can > > > > please gimme a a quicky! > > > > > > > > Am I correct when I say that "mysqldump' only works when the database > > > > is up and running? and if it is true can any one please tell me that > > > > does taking a dump when a database is running is ok. Also the whats > > > > the difference in usage of mysqldump and taking just the backup of the > > > > database. > > > > > > > > Regards > > > > Naufal > > > > > > Yes, mysqldump is just a specialized client for MySQL, it performs all > > > of it's operations through a server. > > > > > > Whereas a raw file dump is, well, a raw file dump, mysqldump generates > > > SQL scripts which will recreate your databases, tables and data when > > > piped in to a simple command line client thus: > > > > > > mysqldump -h localhost -u user -p mydatabase > mydatabase.sql > > > > > > then, it may be recreated > > > > > > mysql -h otherserver -u user -p databasewhichexists < mydatabase.sql > > > > > > (command line examples are for *nix, but windows variants exist) > > > > > > - michael dykman > > > > > > > > > > > > -- > > > - michael dykman > > > - [EMAIL PROTECTED] > > > > > > - All models are wrong. Some models are useful. > > > > > > > -- > > 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: mysql dump
No, but a table lock or two may be expected. This is to PREVENT data loss (which you were also worried about). The mysqldump process will most likely be quick and painless (quick being a relative term, depending on the amount of data in your database(s)). Craig On Nov 13, 2007 2:35 PM, Naufal Sheikh <[EMAIL PROTECTED]> wrote: > So is it safe to take the dump while database is running. I mean is > there any loss of data expected because of taking dump while a > database is running. > > On Nov 13, 2007 2:26 PM, Michael Dykman <[EMAIL PROTECTED]> wrote: > > > > On Nov 13, 2007 2:11 PM, Naufal Sheikh <[EMAIL PROTECTED]> wrote: > > > Hello everyone, > > > > > > Few conceptual questions which I can't understand. If any one can > > > please gimme a a quicky! > > > > > > Am I correct when I say that "mysqldump' only works when the database > > > is up and running? and if it is true can any one please tell me that > > > does taking a dump when a database is running is ok. Also the whats > > > the difference in usage of mysqldump and taking just the backup of the > > > database. > > > > > > Regards > > > Naufal > > > > Yes, mysqldump is just a specialized client for MySQL, it performs all > > of it's operations through a server. > > > > Whereas a raw file dump is, well, a raw file dump, mysqldump generates > > SQL scripts which will recreate your databases, tables and data when > > piped in to a simple command line client thus: > > > > mysqldump -h localhost -u user -p mydatabase > mydatabase.sql > > > > then, it may be recreated > > > > mysql -h otherserver -u user -p databasewhichexists < mydatabase.sql > > > > (command line examples are for *nix, but windows variants exist) > > > > - michael dykman > > > > > > > > -- > > - michael dykman > > - [EMAIL PROTECTED] > > > > - All models are wrong. Some models are useful. > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > >
Re: mysql dump
So is it safe to take the dump while database is running. I mean is there any loss of data expected because of taking dump while a database is running. On Nov 13, 2007 2:26 PM, Michael Dykman <[EMAIL PROTECTED]> wrote: > > On Nov 13, 2007 2:11 PM, Naufal Sheikh <[EMAIL PROTECTED]> wrote: > > Hello everyone, > > > > Few conceptual questions which I can't understand. If any one can > > please gimme a a quicky! > > > > Am I correct when I say that "mysqldump' only works when the database > > is up and running? and if it is true can any one please tell me that > > does taking a dump when a database is running is ok. Also the whats > > the difference in usage of mysqldump and taking just the backup of the > > database. > > > > Regards > > Naufal > > Yes, mysqldump is just a specialized client for MySQL, it performs all > of it's operations through a server. > > Whereas a raw file dump is, well, a raw file dump, mysqldump generates > SQL scripts which will recreate your databases, tables and data when > piped in to a simple command line client thus: > > mysqldump -h localhost -u user -p mydatabase > mydatabase.sql > > then, it may be recreated > > mysql -h otherserver -u user -p databasewhichexists < mydatabase.sql > > (command line examples are for *nix, but windows variants exist) > > - michael dykman > > > > -- > - michael dykman > - [EMAIL PROTECTED] > > - All models are wrong. Some models are useful. > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysql dump
On Nov 13, 2007 2:11 PM, Naufal Sheikh <[EMAIL PROTECTED]> wrote: > Hello everyone, > > Few conceptual questions which I can't understand. If any one can > please gimme a a quicky! > > Am I correct when I say that "mysqldump' only works when the database > is up and running? and if it is true can any one please tell me that > does taking a dump when a database is running is ok. Also the whats > the difference in usage of mysqldump and taking just the backup of the > database. > > Regards > Naufal Yes, mysqldump is just a specialized client for MySQL, it performs all of it's operations through a server. Whereas a raw file dump is, well, a raw file dump, mysqldump generates SQL scripts which will recreate your databases, tables and data when piped in to a simple command line client thus: mysqldump -h localhost -u user -p mydatabase > mydatabase.sql then, it may be recreated mysql -h otherserver -u user -p databasewhichexists < mydatabase.sql (command line examples are for *nix, but windows variants exist) - michael dykman -- - michael dykman - [EMAIL PROTECTED] - All models are wrong. Some models are useful. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysql dump help!
> On 7/24/07, Red Hope <[EMAIL PROTECTED]> wrote: > >mysql> > > > >mysql> \R shell> > >PROMPT set to 'shell>' > > > >shell> It doesn't matter what the prompt says, it's still mysql you're running here. When people say "the shell prompt" they don't mean "make your prompt say the word shell", they mean "the prompt when you're running the shell". Your "shell" prompt is still the mysql prompt, because it is the mysql program's command line. Make sense? mysqldump is *not* a mysql command (like select, create table, use, etc.) mysqldump is a separate program. In Windows, if I remember correctly, the shell is called cmd.exe, so you need to run cmd.exe and at its prompt (aka the shell prompt) type the mysqldump command you want to try. -- Cos -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysql dump help!
I did have some luck, y'all after several hours. Originally there wasn't a mysqldump.exe in the bin folder so I redid everything. I went through regular ole ms-dos and was able to run it through fine. I just needed it to get converted to a .sql file so I can upload it to my web server. I discovered my web server only takes .sql files for the database in the PHPadmin thing. So I'm hoping it'll work out. Thank you all for the help. I'd never figured out if everybody didn't provide the steps to get there! :) Lillian --- Gary Josack <[EMAIL PROTECTED]> wrote: > Red Hope wrote: > > I'm curious about one thing. When I go into MySQL > > folder on the hard drive. I go into the 'bin' > folder, > > should there be an .exe program called mysqldump? > or > > not? > > > > Lillian > > > > > > --- Carlos Proal <[EMAIL PROTECTED]> wrote: > > > > > >> Yep, good for you, welcome to the "real" world > >> You are changing the prompt but are still inside > the > >> dbms, you need to > >> get out, because mysqldump is an application > (.exe > >> file) not a sql > >> command, ie > >> > >> > > > > > > >> Welcome to the MySQL monitor. Commands end with > ; > >> or \g. > >> Your MySQL connection id is 9 > >> Server version: 5.0.41-community-nt-log MySQL > >> Community Edition (GPL) > >> > >> Type 'help;' or '\h' for help. Type '\c' to clear > >> the buffer. > >> > >> mysql> > >> mysql> quit > >> Bye > >> > >> D:\lillian>mysqldump -u root -ppassword test > > >> test.sql; > >> > >> > > > -- > > > >> but maybe after the quit, the window will close, > if > >> that happens, open a > >> new command prompt from "start -> programs -> > >> accesories --> command > >> prompt" and then run mysqldump > >> > >> Carlos > >> > >> > >> Red Hope wrote: > >> > >>> Hey y'all, > >>> I use charming Windows XP on here. I've taken > >>> > >> database > >> > >>> classes but lucky for me we never used *real* > >>> > >> MySQL. > >> > >>> Below I typed up exactly what I put into the > MySQL > >>> prompt and this is what it kicks back to me. > >>> > >>> Lillian > >>> > >>> > >>> > >>> mysql> > >>> > >>> mysql> \R shell> > >>> PROMPT set to 'shell>' > >>> > >>> shell> > >>> > >>> shell>mysqldump -u root -ppassword test > > >>> > >> test.sql; > >> > >>> ERROR 1064 <4200>: You have an error in your SQL > >>> syntax; checkthe manual that corresponds to your > >>> > >> MySQL > >> > >>> server version for the right syntax to use near > >>> 'mysqldump -u root -ppassword test > test.sql' > at > >>> > >> line > >> > >>> 1 > >>> > >>> > >>> > >>> --- Carlos Proal <[EMAIL PROTECTED]> wrote: > >>> > >>> > >>> > Can you email us the complete command and the > > >> error > >> > ? > > Carlos > > > Red Hope wrote: > > > > Well, that went over my head. :) I > understand > > > > > what > > > > you're telling me, how to get there, but not > how > > > > > to do > > > > it. bleh. > > > > When I start up MySQL Command Line Client, I'm > > > > > always > > > > prompted at "mysql>". So I told it to switch > > > >> from > >> > > > > > that > > > > prompt to "shell>" prompt. It always starts up > > > >> in > >> > > "mysql>" prompt. Once I'm in shell, I tried > the > > > > > dump > > > > procedure and it kept saying it couldn't > > > >> connect. > >> > > > > > So I > > > > checked what databases it had, it shows them. > I > > > > > can't > > > > even switch to a database because of no > > > > > connection. > > > > I'm not exactly sure why there's no > 'connection' > > > > > at > > > > all. > > > > Thanks for trying so hard, Carlos! > > Lillian > > > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > === message truncated === Shape Yahoo! in your own image. Join our Network Research Panel today! http://surveylink.yahoo.com/gmrs/yahoo_panel_invite.asp?a=7 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:h
RE: mysql dump help!
Not to ask a perhaps silly question, but are you specifically trying to use mysqldump, or just get a backup copy of your databases? If you just want to back them up download MySQL Administrator -> GUI = fun & easy... :) http://dev.mysql.com/downloads/ (Download MySQL GUI Tools - about half way down the page) Ben Wiechman -Original Message- From: Gary Josack [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 24, 2007 6:50 AM To: Red Hope Cc: mysql@lists.mysql.com Subject: Re: mysql dump help! Red Hope wrote: > I'm curious about one thing. When I go into MySQL > folder on the hard drive. I go into the 'bin' folder, > should there be an .exe program called mysqldump? or > not? > > Lillian > > > --- Carlos Proal <[EMAIL PROTECTED]> wrote: > > >> Yep, good for you, welcome to the "real" world >> You are changing the prompt but are still inside the >> dbms, you need to >> get out, because mysqldump is an application (.exe >> file) not a sql >> command, ie >> >> > > >> Welcome to the MySQL monitor. Commands end with ; >> or \g. >> Your MySQL connection id is 9 >> Server version: 5.0.41-community-nt-log MySQL >> Community Edition (GPL) >> >> Type 'help;' or '\h' for help. Type '\c' to clear >> the buffer. >> >> mysql> >> mysql> quit >> Bye >> >> D:\lillian>mysqldump -u root -ppassword test > >> test.sql; >> >> > -- > >> but maybe after the quit, the window will close, if >> that happens, open a >> new command prompt from "start -> programs -> >> accesories --> command >> prompt" and then run mysqldump >> >> Carlos >> >> >> Red Hope wrote: >> >>> Hey y'all, >>> I use charming Windows XP on here. I've taken >>> >> database >> >>> classes but lucky for me we never used *real* >>> >> MySQL. >> >>> Below I typed up exactly what I put into the MySQL >>> prompt and this is what it kicks back to me. >>> >>> Lillian >>> >>> >>> >>> mysql> >>> >>> mysql> \R shell> >>> PROMPT set to 'shell>' >>> >>> shell> >>> >>> shell>mysqldump -u root -ppassword test > >>> >> test.sql; >> >>> ERROR 1064 <4200>: You have an error in your SQL >>> syntax; checkthe manual that corresponds to your >>> >> MySQL >> >>> server version for the right syntax to use near >>> 'mysqldump -u root -ppassword test > test.sql' at >>> >> line >> >>> 1 >>> >>> >>> >>> --- Carlos Proal <[EMAIL PROTECTED]> wrote: >>> >>> >>> >>>> Can you email us the complete command and the >>>> >> error >> >>>> ? >>>> >>>> Carlos >>>> >>>> >>>> Red Hope wrote: >>>> >>>> >>>>> Well, that went over my head. :) I understand >>>>> >>>>> >>>> what >>>> >>>> >>>>> you're telling me, how to get there, but not how >>>>> >>>>> >>>> to do >>>> >>>> >>>>> it. bleh. >>>>> >>>>> When I start up MySQL Command Line Client, I'm >>>>> >>>>> >>>> always >>>> >>>> >>>>> prompted at "mysql>". So I told it to switch >>>>> >> from >> >>>>> >>>>> >>>> that >>>> >>>> >>>>> prompt to "shell>" prompt. It always starts up >>>>> >> in >> >>>>> "mysql>" prompt. Once I'm in shell, I tried the >>>>> >>>>> >>>> dump >>>> >>>> >>>>> procedure and it kept saying it couldn
Re: mysql dump help!
Red Hope wrote: I'm curious about one thing. When I go into MySQL folder on the hard drive. I go into the 'bin' folder, should there be an .exe program called mysqldump? or not? Lillian --- Carlos Proal <[EMAIL PROTECTED]> wrote: Yep, good for you, welcome to the "real" world You are changing the prompt but are still inside the dbms, you need to get out, because mysqldump is an application (.exe file) not a sql command, ie Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 9 Server version: 5.0.41-community-nt-log MySQL Community Edition (GPL) Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> mysql> quit Bye D:\lillian>mysqldump -u root -ppassword test > test.sql; -- but maybe after the quit, the window will close, if that happens, open a new command prompt from "start -> programs -> accesories --> command prompt" and then run mysqldump Carlos Red Hope wrote: Hey y'all, I use charming Windows XP on here. I've taken database classes but lucky for me we never used *real* MySQL. Below I typed up exactly what I put into the MySQL prompt and this is what it kicks back to me. Lillian mysql> mysql> \R shell> PROMPT set to 'shell>' shell> shell>mysqldump -u root -ppassword test > test.sql; ERROR 1064 <4200>: You have an error in your SQL syntax; checkthe manual that corresponds to your MySQL server version for the right syntax to use near 'mysqldump -u root -ppassword test > test.sql' at line 1 --- Carlos Proal <[EMAIL PROTECTED]> wrote: Can you email us the complete command and the error ? Carlos Red Hope wrote: Well, that went over my head. :) I understand what you're telling me, how to get there, but not how to do it. bleh. When I start up MySQL Command Line Client, I'm always prompted at "mysql>". So I told it to switch from that prompt to "shell>" prompt. It always starts up in "mysql>" prompt. Once I'm in shell, I tried the dump procedure and it kept saying it couldn't connect. So I checked what databases it had, it shows them. I can't even switch to a database because of no connection. I'm not exactly sure why there's no 'connection' at all. Thanks for trying so hard, Carlos! Lillian -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] Got a little couch potato? Check out fun summer activities for kids. http://search.yahoo.com/search?fr=oni_on_mail&p=summer+activities+for+kids&cs=bz -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] Luggage? GPS? Comic books? Check out fitting gifts for grads at Yahoo! Search http://search.yahoo.com/search?fr=oni_on_mail&p=graduation+gifts&cs=bz As far as i know there SHOULD be a mysqldump.exe in your mysql bin folder. On windows it should be: Start, Run, Type "cmd", Enter At the Command Prompt cd to your MySQL directory. For Example: "cd C:\mysql\bin", Enter then "mysqldump -u root -ppassword test > test.sql"", Enter That will place that .sql file in that directory for now which you can move as you please through Explorer. You do NOT want to run this from the MySQL client. mysqldump is a completely separate program that is run from the Operating Systems command line. I hope this helps. if not, just keep trying. you are very close. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysql dump help!
did u try this mysqldump -u root -ppassword --database test > test.sql On 7/24/07, Red Hope <[EMAIL PROTECTED]> wrote: I'm curious about one thing. When I go into MySQL folder on the hard drive. I go into the 'bin' folder, should there be an .exe program called mysqldump? or not? Lillian --- Carlos Proal <[EMAIL PROTECTED]> wrote: > > Yep, good for you, welcome to the "real" world > You are changing the prompt but are still inside the > dbms, you need to > get out, because mysqldump is an application (.exe > file) not a sql > command, ie > > Welcome to the MySQL monitor. Commands end with ; > or \g. > Your MySQL connection id is 9 > Server version: 5.0.41-community-nt-log MySQL > Community Edition (GPL) > > Type 'help;' or '\h' for help. Type '\c' to clear > the buffer. > > mysql> > mysql> quit > Bye > > D:\lillian>mysqldump -u root -ppassword test > > test.sql; > -- > > but maybe after the quit, the window will close, if > that happens, open a > new command prompt from "start -> programs -> > accesories --> command > prompt" and then run mysqldump > > Carlos > > > Red Hope wrote: > > Hey y'all, > > I use charming Windows XP on here. I've taken > database > > classes but lucky for me we never used *real* > MySQL. > > Below I typed up exactly what I put into the MySQL > > prompt and this is what it kicks back to me. > > > > Lillian > > > > > > > > mysql> > > > > mysql> \R shell> > > PROMPT set to 'shell>' > > > > shell> > > > > shell>mysqldump -u root -ppassword test > > test.sql; > > ERROR 1064 <4200>: You have an error in your SQL > > syntax; checkthe manual that corresponds to your > MySQL > > server version for the right syntax to use near > > 'mysqldump -u root -ppassword test > test.sql' at > line > > 1 > > > > > > > > --- Carlos Proal <[EMAIL PROTECTED]> wrote: > > > > > >> Can you email us the complete command and the > error > >> ? > >> > >> Carlos > >> > >> > >> Red Hope wrote: > >> > >>> Well, that went over my head. :) I understand > >>> > >> what > >> > >>> you're telling me, how to get there, but not how > >>> > >> to do > >> > >>> it. bleh. > >>> > >>> When I start up MySQL Command Line Client, I'm > >>> > >> always > >> > >>> prompted at "mysql>". So I told it to switch > from > >>> > >> that > >> > >>> prompt to "shell>" prompt. It always starts up > in > >>> "mysql>" prompt. Once I'm in shell, I tried the > >>> > >> dump > >> > >>> procedure and it kept saying it couldn't > connect. > >>> > >> So I > >> > >>> checked what databases it had, it shows them. I > >>> > >> can't > >> > >>> even switch to a database because of no > >>> > >> connection. > >> > >>> I'm not exactly sure why there's no 'connection' > >>> > >> at > >> > >>> all. > >>> > >>> Thanks for trying so hard, Carlos! > >>> Lillian > >>> > >>> > >> -- > >> MySQL General Mailing List > >> For list archives: http://lists.mysql.com/mysql > >> To unsubscribe: > >> > >> > > > http://lists.mysql.com/[EMAIL PROTECTED] > > > >> > > > > > > > > > > > > > Got a little couch potato? > > Check out fun summer activities for kids. > > > http://search.yahoo.com/search?fr=oni_on_mail&p=summer+activities+for+kids&cs=bz > > > > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > Luggage? GPS? Comic books? Check out fitting gifts for grads at Yahoo! Search http://search.yahoo.com/search?fr=oni_on_mail&p=graduation+gifts&cs=bz -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysql dump help!
I'm curious about one thing. When I go into MySQL folder on the hard drive. I go into the 'bin' folder, should there be an .exe program called mysqldump? or not? Lillian --- Carlos Proal <[EMAIL PROTECTED]> wrote: > > Yep, good for you, welcome to the "real" world > You are changing the prompt but are still inside the > dbms, you need to > get out, because mysqldump is an application (.exe > file) not a sql > command, ie > > Welcome to the MySQL monitor. Commands end with ; > or \g. > Your MySQL connection id is 9 > Server version: 5.0.41-community-nt-log MySQL > Community Edition (GPL) > > Type 'help;' or '\h' for help. Type '\c' to clear > the buffer. > > mysql> > mysql> quit > Bye > > D:\lillian>mysqldump -u root -ppassword test > > test.sql; > -- > > but maybe after the quit, the window will close, if > that happens, open a > new command prompt from "start -> programs -> > accesories --> command > prompt" and then run mysqldump > > Carlos > > > Red Hope wrote: > > Hey y'all, > > I use charming Windows XP on here. I've taken > database > > classes but lucky for me we never used *real* > MySQL. > > Below I typed up exactly what I put into the MySQL > > prompt and this is what it kicks back to me. > > > > Lillian > > > > > > > > mysql> > > > > mysql> \R shell> > > PROMPT set to 'shell>' > > > > shell> > > > > shell>mysqldump -u root -ppassword test > > test.sql; > > ERROR 1064 <4200>: You have an error in your SQL > > syntax; checkthe manual that corresponds to your > MySQL > > server version for the right syntax to use near > > 'mysqldump -u root -ppassword test > test.sql' at > line > > 1 > > > > > > > > --- Carlos Proal <[EMAIL PROTECTED]> wrote: > > > > > >> Can you email us the complete command and the > error > >> ? > >> > >> Carlos > >> > >> > >> Red Hope wrote: > >> > >>> Well, that went over my head. :) I understand > >>> > >> what > >> > >>> you're telling me, how to get there, but not how > >>> > >> to do > >> > >>> it. bleh. > >>> > >>> When I start up MySQL Command Line Client, I'm > >>> > >> always > >> > >>> prompted at "mysql>". So I told it to switch > from > >>> > >> that > >> > >>> prompt to "shell>" prompt. It always starts up > in > >>> "mysql>" prompt. Once I'm in shell, I tried the > >>> > >> dump > >> > >>> procedure and it kept saying it couldn't > connect. > >>> > >> So I > >> > >>> checked what databases it had, it shows them. I > >>> > >> can't > >> > >>> even switch to a database because of no > >>> > >> connection. > >> > >>> I'm not exactly sure why there's no 'connection' > >>> > >> at > >> > >>> all. > >>> > >>> Thanks for trying so hard, Carlos! > >>> Lillian > >>> > >>> > >> -- > >> MySQL General Mailing List > >> For list archives: http://lists.mysql.com/mysql > >> To unsubscribe: > >> > >> > > > http://lists.mysql.com/[EMAIL PROTECTED] > > > >> > > > > > > > > > > > > > Got a little couch potato? > > Check out fun summer activities for kids. > > > http://search.yahoo.com/search?fr=oni_on_mail&p=summer+activities+for+kids&cs=bz > > > > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > Luggage? GPS? Comic books? Check out fitting gifts for grads at Yahoo! Search http://search.yahoo.com/search?fr=oni_on_mail&p=graduation+gifts&cs=bz -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysql dump help!
I cut and pasted what you typed and just altered the password. It didn't like it all. Same error again. If I put any command in without the ";" at the end then I'll get locked into this "->" thingy unless I clear out. I can't guess why it won't take it. Lillian --- Ananda Kumar <[EMAIL PROTECTED]> wrote: > try this > > mysqldump -u root -ppassword --database test > > test.sql > > On 7/24/07, Red Hope <[EMAIL PROTECTED]> wrote: > > > > Hey y'all, > > I use charming Windows XP on here. I've taken > database > > classes but lucky for me we never used *real* > MySQL. > > Below I typed up exactly what I put into the MySQL > > prompt and this is what it kicks back to me. > > > > Lillian > > > > > > > > mysql> > > > > mysql> \R shell> > > PROMPT set to 'shell>' > > > > shell> > > > > shell>mysqldump -u root -ppassword test > > test.sql; > > ERROR 1064 <4200>: You have an error in your SQL > > syntax; checkthe manual that corresponds to your > MySQL > > server version for the right syntax to use near > > 'mysqldump -u root -ppassword test > test.sql' at > line > > 1 > > > > > > > > --- Carlos Proal <[EMAIL PROTECTED]> wrote: > > > > > > > > Can you email us the complete command and the > error > > > ? > > > > > > Carlos > > > > > > > > > Red Hope wrote: > > > > Well, that went over my head. :) I > understand > > > what > > > > you're telling me, how to get there, but not > how > > > to do > > > > it. bleh. > > > > > > > > When I start up MySQL Command Line Client, I'm > > > always > > > > prompted at "mysql>". So I told it to switch > from > > > that > > > > prompt to "shell>" prompt. It always starts up > in > > > > "mysql>" prompt. Once I'm in shell, I tried > the > > > dump > > > > procedure and it kept saying it couldn't > connect. > > > So I > > > > checked what databases it had, it shows them. > I > > > can't > > > > even switch to a database because of no > > > connection. > > > > I'm not exactly sure why there's no > 'connection' > > > at > > > > all. > > > > > > > > Thanks for trying so hard, Carlos! > > > > Lillian > > > > > > > > > > > > > -- > > > MySQL General Mailing List > > > For list archives: http://lists.mysql.com/mysql > > > To unsubscribe: > > > > > > http://lists.mysql.com/[EMAIL PROTECTED] > > > > > > > > > > > > > > > > > > > > > Got a little couch potato? > > Check out fun summer activities for kids. > > > > > http://search.yahoo.com/search?fr=oni_on_mail&p=summer+activities+for+kids&cs=bz > > > > -- > > MySQL General Mailing List > > For list archives: http://lists.mysql.com/mysql > > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > > > > Need a vacation? Get great deals to amazing places on Yahoo! Travel. http://travel.yahoo.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysql dump help!
Yep, good for you, welcome to the "real" world You are changing the prompt but are still inside the dbms, you need to get out, because mysqldump is an application (.exe file) not a sql command, ie Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 9 Server version: 5.0.41-community-nt-log MySQL Community Edition (GPL) Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> mysql> quit Bye D:\lillian>mysqldump -u root -ppassword test > test.sql; -- but maybe after the quit, the window will close, if that happens, open a new command prompt from "start -> programs -> accesories --> command prompt" and then run mysqldump Carlos Red Hope wrote: Hey y'all, I use charming Windows XP on here. I've taken database classes but lucky for me we never used *real* MySQL. Below I typed up exactly what I put into the MySQL prompt and this is what it kicks back to me. Lillian mysql> mysql> \R shell> PROMPT set to 'shell>' shell> shell>mysqldump -u root -ppassword test > test.sql; ERROR 1064 <4200>: You have an error in your SQL syntax; checkthe manual that corresponds to your MySQL server version for the right syntax to use near 'mysqldump -u root -ppassword test > test.sql' at line 1 --- Carlos Proal <[EMAIL PROTECTED]> wrote: Can you email us the complete command and the error ? Carlos Red Hope wrote: Well, that went over my head. :) I understand what you're telling me, how to get there, but not how to do it. bleh. When I start up MySQL Command Line Client, I'm always prompted at "mysql>". So I told it to switch from that prompt to "shell>" prompt. It always starts up in "mysql>" prompt. Once I'm in shell, I tried the dump procedure and it kept saying it couldn't connect. So I checked what databases it had, it shows them. I can't even switch to a database because of no connection. I'm not exactly sure why there's no 'connection' at all. Thanks for trying so hard, Carlos! Lillian -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] Got a little couch potato? Check out fun summer activities for kids. http://search.yahoo.com/search?fr=oni_on_mail&p=summer+activities+for+kids&cs=bz -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysql dump help!
try this mysqldump -u root -ppassword --database test > test.sql On 7/24/07, Red Hope <[EMAIL PROTECTED]> wrote: Hey y'all, I use charming Windows XP on here. I've taken database classes but lucky for me we never used *real* MySQL. Below I typed up exactly what I put into the MySQL prompt and this is what it kicks back to me. Lillian mysql> mysql> \R shell> PROMPT set to 'shell>' shell> shell>mysqldump -u root -ppassword test > test.sql; ERROR 1064 <4200>: You have an error in your SQL syntax; checkthe manual that corresponds to your MySQL server version for the right syntax to use near 'mysqldump -u root -ppassword test > test.sql' at line 1 --- Carlos Proal <[EMAIL PROTECTED]> wrote: > > Can you email us the complete command and the error > ? > > Carlos > > > Red Hope wrote: > > Well, that went over my head. :) I understand > what > > you're telling me, how to get there, but not how > to do > > it. bleh. > > > > When I start up MySQL Command Line Client, I'm > always > > prompted at "mysql>". So I told it to switch from > that > > prompt to "shell>" prompt. It always starts up in > > "mysql>" prompt. Once I'm in shell, I tried the > dump > > procedure and it kept saying it couldn't connect. > So I > > checked what databases it had, it shows them. I > can't > > even switch to a database because of no > connection. > > I'm not exactly sure why there's no 'connection' > at > > all. > > > > Thanks for trying so hard, Carlos! > > Lillian > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > Got a little couch potato? Check out fun summer activities for kids. http://search.yahoo.com/search?fr=oni_on_mail&p=summer+activities+for+kids&cs=bz -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysql dump help!
Hey y'all, I use charming Windows XP on here. I've taken database classes but lucky for me we never used *real* MySQL. Below I typed up exactly what I put into the MySQL prompt and this is what it kicks back to me. Lillian mysql> mysql> \R shell> PROMPT set to 'shell>' shell> shell>mysqldump -u root -ppassword test > test.sql; ERROR 1064 <4200>: You have an error in your SQL syntax; checkthe manual that corresponds to your MySQL server version for the right syntax to use near 'mysqldump -u root -ppassword test > test.sql' at line 1 --- Carlos Proal <[EMAIL PROTECTED]> wrote: > > Can you email us the complete command and the error > ? > > Carlos > > > Red Hope wrote: > > Well, that went over my head. :) I understand > what > > you're telling me, how to get there, but not how > to do > > it. bleh. > > > > When I start up MySQL Command Line Client, I'm > always > > prompted at "mysql>". So I told it to switch from > that > > prompt to "shell>" prompt. It always starts up in > > "mysql>" prompt. Once I'm in shell, I tried the > dump > > procedure and it kept saying it couldn't connect. > So I > > checked what databases it had, it shows them. I > can't > > even switch to a database because of no > connection. > > I'm not exactly sure why there's no 'connection' > at > > all. > > > > Thanks for trying so hard, Carlos! > > Lillian > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > Got a little couch potato? Check out fun summer activities for kids. http://search.yahoo.com/search?fr=oni_on_mail&p=summer+activities+for+kids&cs=bz -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysql dump help!
I think we are daling with a windows user, who are not that familiar with a command prompt. Correct me if i'm wrong. How to get to a point where you would be able to execute a mysqldump, will depend on what OS you are running, and how you installed MySQL. On Tue, July 24, 2007 04:41, Carlos Proal wrote: > > Can you email us the complete command and the error ? > > Carlos > > > Red Hope wrote: >> Well, that went over my head. :) I understand what >> you're telling me, how to get there, but not how to do >> it. bleh. >> >> When I start up MySQL Command Line Client, I'm always >> prompted at "mysql>". So I told it to switch from that >> prompt to "shell>" prompt. It always starts up in >> "mysql>" prompt. Once I'm in shell, I tried the dump >> procedure and it kept saying it couldn't connect. So I >> checked what databases it had, it shows them. I can't >> even switch to a database because of no connection. >> I'm not exactly sure why there's no 'connection' at >> all. >> >> Thanks for trying so hard, Carlos! >> Lillian >> > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] > > > -- > This message has been scanned for viruses and > dangerous content by MailScanner, and is > believed to be clean. > -- Later Mogens Melander +45 40 85 71 38 +66 870 133 224 -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysql dump help!
mysqldump -u -p -q --single-transaction --tab=/dest/dir database or mysql -u root -p database > output.sql On Tue, July 24, 2007 03:16, Red Hope wrote: > Hey y'all, > I've been fussing with the MySQL dump procedure to > backup my stuff. I'm on MySQL 5.0.41 and I have tried > so hard to get it to dump my files into .sql format > but my syntax is wrong, wrong, wrong. lol > > I put below examples what I've been entering to get my > databases backed up. I always get an error or I get > locked into the "->" thing if I don't use the > semicolons. Hmmm, try \q before typing mysqldump ;^) > > Any help would be awesome! > Thank you, > Lillian > > Tried & Wrong > mysqldump -u root -ppassword test > test.sql > mysqldump -u root -ppassword test > test.sql; > mysqldump -u root -ppassword -databases test > > test.sql; > > > > > > > > Yahoo! oneSearch: Finally, mobile search > that gives answers, not web links. > http://mobile.yahoo.com/mobileweb/onesearch?refer=1ONXIC > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] > > > -- > This message has been scanned for viruses and > dangerous content by MailScanner, and is > believed to be clean. > -- Later Mogens Melander +45 40 85 71 38 +66 870 133 224 -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysql dump help!
Can you email us the complete command and the error ? Carlos Red Hope wrote: Well, that went over my head. :) I understand what you're telling me, how to get there, but not how to do it. bleh. When I start up MySQL Command Line Client, I'm always prompted at "mysql>". So I told it to switch from that prompt to "shell>" prompt. It always starts up in "mysql>" prompt. Once I'm in shell, I tried the dump procedure and it kept saying it couldn't connect. So I checked what databases it had, it shows them. I can't even switch to a database because of no connection. I'm not exactly sure why there's no 'connection' at all. Thanks for trying so hard, Carlos! Lillian -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysql dump help!
Well, that went over my head. :) I understand what you're telling me, how to get there, but not how to do it. bleh. When I start up MySQL Command Line Client, I'm always prompted at "mysql>". So I told it to switch from that prompt to "shell>" prompt. It always starts up in "mysql>" prompt. Once I'm in shell, I tried the dump procedure and it kept saying it couldn't connect. So I checked what databases it had, it shows them. I can't even switch to a database because of no connection. I'm not exactly sure why there's no 'connection' at all. Thanks for trying so hard, Carlos! Lillian --- Carlos Proal <[EMAIL PROTECTED]> wrote: > > Well hopefully, typing "quit" at the mysql console > get you back to the > shell. > > Otherwise, you need to open a Gnome Console, KDE > Konsole or Windows > CommandPrompt from the different menus on your > operating system > > If the mysql directory is on your PATH you can use > mysqldump anywhere, > if not, move to the mysql/bin directory and then you > can run it without > any problem. > > Hope that help. > > Carlos > > > Red Hope wrote: > > Oh boy, and here's the big stupid question. How do > I > > get to the shell prompt? Sorry! Yea, I'm that > newbie. > > :) > > > > Thank you, > > Lillian > > > > > > --- Carlos Proal <[EMAIL PROTECTED]> wrote: > > > > > >> One common error is trying to do this inside the > >> mysql console, instead > >> of the shell prompt, i think thats your problem > >> because at least the > >> first one is correct. > >> > >> Carlos > >> > >> > >> Red Hope wrote: > >> > >>> Hey y'all, > >>> I've been fussing with the MySQL dump procedure > to > >>> backup my stuff. I'm on MySQL 5.0.41 and I have > >>> > >> tried > >> > >>> so hard to get it to dump my files into .sql > >>> > >> format > >> > >>> but my syntax is wrong, wrong, wrong. lol > >>> > >>> I put below examples what I've been entering to > >>> > >> get my > >> > >>> databases backed up. I always get an error or I > >>> > >> get > >> > >>> locked into the "->" thing if I don't use the > >>> semicolons. > >>> > >>> Any help would be awesome! > >>> Thank you, > >>> Lillian > >>> > >>> Tried & Wrong > >>> mysqldump -u root -ppassword test > test.sql > >>> mysqldump -u root -ppassword test > test.sql; > >>> mysqldump -u root -ppassword -databases test > > >>> test.sql; > >>> > >>> > >>> > >>> > >>> > >>> > >>> > >>> > > > > > > >>> Yahoo! oneSearch: Finally, mobile search > >>> that gives answers, not web links. > >>> > >>> > > > http://mobile.yahoo.com/mobileweb/onesearch?refer=1ONXIC > > > >>> > >>> > >> -- > >> MySQL General Mailing List > >> For list archives: http://lists.mysql.com/mysql > >> To unsubscribe: > >> > >> > > > http://lists.mysql.com/[EMAIL PROTECTED] > > > >> > > > > > > > > > > > > > Take the Internet to Go: Yahoo!Go puts the > Internet in your pocket: mail, news, photos & more. > > http://mobile.yahoo.com/go?refer=1GNXIC > > > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > Fussy? Opinionated? Impossible to please? Perfect. Join Yahoo!'s user panel and lay it on us. http://surveylink.yahoo.com/gmrs/yahoo_panel_invite.asp?a=7 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysql dump help!
Well hopefully, typing "quit" at the mysql console get you back to the shell. Otherwise, you need to open a Gnome Console, KDE Konsole or Windows CommandPrompt from the different menus on your operating system If the mysql directory is on your PATH you can use mysqldump anywhere, if not, move to the mysql/bin directory and then you can run it without any problem. Hope that help. Carlos Red Hope wrote: Oh boy, and here's the big stupid question. How do I get to the shell prompt? Sorry! Yea, I'm that newbie. :) Thank you, Lillian --- Carlos Proal <[EMAIL PROTECTED]> wrote: One common error is trying to do this inside the mysql console, instead of the shell prompt, i think thats your problem because at least the first one is correct. Carlos Red Hope wrote: Hey y'all, I've been fussing with the MySQL dump procedure to backup my stuff. I'm on MySQL 5.0.41 and I have tried so hard to get it to dump my files into .sql format but my syntax is wrong, wrong, wrong. lol I put below examples what I've been entering to get my databases backed up. I always get an error or I get locked into the "->" thing if I don't use the semicolons. Any help would be awesome! Thank you, Lillian Tried & Wrong mysqldump -u root -ppassword test > test.sql mysqldump -u root -ppassword test > test.sql; mysqldump -u root -ppassword -databases test > test.sql; Yahoo! oneSearch: Finally, mobile search that gives answers, not web links. http://mobile.yahoo.com/mobileweb/onesearch?refer=1ONXIC -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] Take the Internet to Go: Yahoo!Go puts the Internet in your pocket: mail, news, photos & more. http://mobile.yahoo.com/go?refer=1GNXIC -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysql dump help!
Oh boy, and here's the big stupid question. How do I get to the shell prompt? Sorry! Yea, I'm that newbie. :) Thank you, Lillian --- Carlos Proal <[EMAIL PROTECTED]> wrote: > > One common error is trying to do this inside the > mysql console, instead > of the shell prompt, i think thats your problem > because at least the > first one is correct. > > Carlos > > > Red Hope wrote: > > Hey y'all, > > I've been fussing with the MySQL dump procedure to > > backup my stuff. I'm on MySQL 5.0.41 and I have > tried > > so hard to get it to dump my files into .sql > format > > but my syntax is wrong, wrong, wrong. lol > > > > I put below examples what I've been entering to > get my > > databases backed up. I always get an error or I > get > > locked into the "->" thing if I don't use the > > semicolons. > > > > Any help would be awesome! > > Thank you, > > Lillian > > > > Tried & Wrong > > mysqldump -u root -ppassword test > test.sql > > mysqldump -u root -ppassword test > test.sql; > > mysqldump -u root -ppassword -databases test > > > test.sql; > > > > > > > > > > > > > > > > > Yahoo! oneSearch: Finally, mobile search > > that gives answers, not web links. > > > http://mobile.yahoo.com/mobileweb/onesearch?refer=1ONXIC > > > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > Take the Internet to Go: Yahoo!Go puts the Internet in your pocket: mail, news, photos & more. http://mobile.yahoo.com/go?refer=1GNXIC -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysql dump help!
One common error is trying to do this inside the mysql console, instead of the shell prompt, i think thats your problem because at least the first one is correct. Carlos Red Hope wrote: Hey y'all, I've been fussing with the MySQL dump procedure to backup my stuff. I'm on MySQL 5.0.41 and I have tried so hard to get it to dump my files into .sql format but my syntax is wrong, wrong, wrong. lol I put below examples what I've been entering to get my databases backed up. I always get an error or I get locked into the "->" thing if I don't use the semicolons. Any help would be awesome! Thank you, Lillian Tried & Wrong mysqldump -u root -ppassword test > test.sql mysqldump -u root -ppassword test > test.sql; mysqldump -u root -ppassword -databases test > test.sql; Yahoo! oneSearch: Finally, mobile search that gives answers, not web links. http://mobile.yahoo.com/mobileweb/onesearch?refer=1ONXIC -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL dump (OT?)
You could try setting up FileMaker to query MySQL directly, using ODBC. Otherwise, you can't create a FileMaker database directly, so you need to create an import format that FileMaker understands (tab, command, sylk, etc.). You would need to keep in mind that you may have embedded returns and/or tabs in your data that would screw up things like tab-delimited or comma delimited formats. For embedded returns, FileMaker uses vertical tabs (ascii 11). So you would need to convert all your returns (ascii 13) to vertical tabs before exporting in a tab-delimited format. Embedded tabs you'll have to come up with some other scheme, like replacing them with 4 spaces before exporting from MySQL. On Feb 14, 2005, at 8:47 AM, Erich Beyrent wrote: Hi all, This is perhaps off-topic, but I need to dump my MySQL database into a format that FileMaker Pro will understand. Does anyone have any tips for doing this? Thanks in advance, Erich -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- Brent Baisley Systems Architect Landover Associates, Inc. Search & Advisory Services for Advanced Technology Environments p: 212.759.6400/800.759.0577 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MYSQL DUMP FILES
On Saturday 14 August 2004 01:06 am, [EMAIL PROTECTED] wrote: > mysql> mysqldump b > -> c:/hdump/dump.sql Do it from the command line, not mysql command prompt. -- === Jabber: tradergt@(smelser.org|jabber.org) Quote: "We don't make policy, we just clean up after it." -- Louis Mamakos === pgpof4lKY7bbt.pgp Description: PGP signature
Re: MySQL Dump Command Does Not Consider Foreign Key Dependencies
Stephen, in <= 4.0, you should put SET FOREIGN_KEY_CHECKS=0; at the start of the dump file. In 4.1, mysqldump knows to add to a dump file a line /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0*/ to disable foreign key checks in the dump file. Best regards, Heikki Tuuri Innobase Oy Foreign keys, transactions, and row level locking for MySQL InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM tables http://www.innodb.com/order.php Register now for the 2004 MySQL Users Conference! http://www.mysql.com/events/uc2004/index.html - Original Message - From: "Stephen Cuppett" <[EMAIL PROTECTED]> Newsgroups: mailing.database.myodbc Sent: Friday, March 05, 2004 8:11 PM Subject: MySQL Dump Command Does Not Consider Foreign Key Dependencies > >Description: > The current mysqldump utility does an alphabetical dump of the > tables as well as a row by row dump of the data following each > table declaration. This is adequate enough for most > databases; however, if there are strict foreign key > constraints, the ordering will not always be conducive to > utilizing mysqldump output to restore databases causing major > headaches in order to restore when the table structures are > sophisticated and/or if there is considerable BLOB output in > the output. > >How-To-Repeat: > I apologize for any syntactical mistakes, but I'm sure you can > get the idea. Consider two tables: a,b. After creating > these tables, defining several columns, and then implementing > foreign keys, if "a" has a > foreign key constraint on yet-to-be-created "b" in dump output, > then "a" will fail to create. Further, even if "a" were to be > created, data input into "a" would fail without the supporting > rows in "b". > >Fix: > Ultimately, a dependency graph needs to be considered before > dumping in order to dump the tables and data in an order that > will allow the output to be used to restore the data rather > than alphabetical. However, if we assume that the data > existing now is in a normal state (simplified to mean, > fulfills foreign key constraints), then we could dump > structure and data in same order, but suppress details about > the foreign key constraints and have those appended to the > dump output as ALTER TABLE statements. I believe the latter > to be a much simpler fix and would eliminate this problem. > > >Submitter-Id: > >Originator:Stephen Cuppett > >Organization: > > >MySQL support: none > >Synopsis: Dump Data ABC order Inconsiderate of Foreign Key > Constraints > >Severity: serious > >Priority: medium > >Category: mysql > >Class: change-request > >Release: mysql-4.0.17-standard (Official MySQL RPM) > > >C compiler:2.95.3 > >C++ compiler: 2.95.3 > >Environment: > > System: Linux cuppett1 2.4.21-192-smp #1 SMP Wed Feb 18 19:31:29 UTC > 2004 i686 athlon i386 GNU/Linux > Architecture: i686 > > Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc > /usr/bin/cc > GCC: Reading specs from /usr/lib/gcc-lib/i586-suse-linux/3.3.1/specs > Configured with: ../configure --enable-threads=posix --prefix=/usr > --with-local-prefix=/usr/local --infodir=/usr/share/info > --mandir=/usr/share/man --libdir=/usr/lib > --enable-languages=c,c++,f77,objc,java,ada --disable-checking > --enable-libgcj --with-gxx-include-dir=/usr/include/g++ > --with-slibdir=/lib --with-system-zlib --enable-shared > --enable-__cxa_atexit i586-suse-linux > Thread model: posix > gcc version 3.3.1 (SuSE Linux) > Compilation info: CC='gcc' CFLAGS='-O2 -mcpu=i486 > -fno-strength-reduce' CXX='g++' CXXFLAGS='-O2 -mcpu=i486 > -fno-strength-reduce-felide-constructors -fno-exceptions > -fno-rtti ' LDFLAGS='' ASFLAGS='' > LIBC: > -rwxr-xr-x1 root root 1469811 2003-09-23 19:05 /lib/libc.so.6 > -rw-r--r--1 root root 13553180 2003-09-23 12:04 /usr/lib/libc.a > -rw-r--r--1 root root 204 2003-09-23 12:04 /usr/lib/libc.so > -rw-r--r--1 root root 982008 2003-09-23 14:29 > /usr/lib/libc-client.a > lrwxrwxrwx1 root root 20 2004-01-08 19:04 > /usr/lib/libc-client.so -> libc-client.so.2002d > -rwxr-xr-x1 root root 770436 2003-09-23 14:29 > /usr/lib/libc-client.so.2002d > Configure command: ./configure '--disable-shared' > '--with-mysqld-ldflags=-all-static' '--with-client-ldflags=-all-static' > '--with-server-suffix=-standard' '--without-embedded-server' > '--without-berkeley-db' '--with-innodb' '--without-vio' > '--without-openssl' '--enable-assembler' '--enable-local-infile' > '--with-mysqld-user=mysql' > '--with-unix-socket-path=/var/lib/mysql/mysql.sock' '--prefix=/' > '--with-extra-charsets=complex' '--
RE: MySQL Dump Command Does Not Consider Foreign Key Dependencies
i turn off the checks before a dump in order to restore it properly.
In my scripts looks like:
echo "SET FOREIGN_KEY_CHECKS=0;" >
${mysql_backup_directory}/${2}/${database_filename}
mysqldump --opt -h $2 -P $3 -u $db_username --password=$db_password $1 >>
${mysql_backup_directory}/${2}/${database_filename} 2>> $logfile
}
I would suggest that this can be included as a mysqldump option (--nochecks
or similar).
Carlos
Original Message Follows
From: Stephen Cuppett <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Subject: MySQL Dump Command Does Not Consider Foreign Key Dependencies
Date: Fri, 05 Mar 2004 13:06:09 -0500
>Description:
The current mysqldump utility does an alphabetical dump of the
tables as well as a row by row dump of the data following each
table declaration. This is adequate enough for most
databases; however, if there are strict foreign key
constraints, the ordering will not always be conducive to
utilizing mysqldump output to restore databases causing major
headaches in order to restore when the table structures are
sophisticated and/or if there is considerable BLOB output in
the output.
>How-To-Repeat:
I apologize for any syntactical mistakes, but I'm sure you can
get the idea. Consider two tables: a,b. After creating
these tables, defining several columns, and then implementing
foreign keys, if "a" has a
foreign key constraint on yet-to-be-created "b" in dump output,
then "a" will fail to create. Further, even if "a" were to be
created, data input into "a" would fail without the supporting
rows in "b".
>Fix:
Ultimately, a dependency graph needs to be considered before
dumping in order to dump the tables and data in an order that
will allow the output to be used to restore the data rather
than alphabetical. However, if we assume that the data
existing now is in a normal state (simplified to mean,
fulfills foreign key constraints), then we could dump
structure and data in same order, but suppress details about
the foreign key constraints and have those appended to the
dump output as ALTER TABLE statements. I believe the latter
to be a much simpler fix and would eliminate this problem.
>Submitter-Id:
>Originator:Stephen Cuppett
>Organization:
>MySQL support: none
>Synopsis: Dump Data ABC order Inconsiderate of Foreign Key
Constraints
>Severity: serious
>Priority: medium
>Category: mysql
>Class: change-request
>Release: mysql-4.0.17-standard (Official MySQL RPM)
>C compiler:2.95.3
>C++ compiler: 2.95.3
>Environment:
System: Linux cuppett1 2.4.21-192-smp #1 SMP Wed Feb 18 19:31:29 UTC 2004
i686 athlon i386 GNU/Linux
Architecture: i686
Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc
/usr/bin/cc
GCC: Reading specs from /usr/lib/gcc-lib/i586-suse-linux/3.3.1/specs
Configured with: ../configure --enable-threads=posix --prefix=/usr
--with-local-prefix=/usr/local --infodir=/usr/share/info
--mandir=/usr/share/man --libdir=/usr/lib
--enable-languages=c,c++,f77,objc,java,ada --disable-checking
--enable-libgcj --with-gxx-include-dir=/usr/include/g++ --with-slibdir=/lib
--with-system-zlib --enable-shared --enable-__cxa_atexit i586-suse-linux
Thread model: posix
gcc version 3.3.1 (SuSE Linux)
Compilation info: CC='gcc' CFLAGS='-O2 -mcpu=i486 -fno-strength-reduce'
CXX='g++' CXXFLAGS='-O2 -mcpu=i486 -fno-strength-reduce
-felide-constructors -fno-exceptions -fno-rtti '
LDFLAGS='' ASFLAGS=''
LIBC:
-rwxr-xr-x1 root root 1469811 2003-09-23 19:05 /lib/libc.so.6
-rw-r--r--1 root root 13553180 2003-09-23 12:04 /usr/lib/libc.a
-rw-r--r--1 root root 204 2003-09-23 12:04 /usr/lib/libc.so
-rw-r--r--1 root root 982008 2003-09-23 14:29
/usr/lib/libc-client.a
lrwxrwxrwx1 root root 20 2004-01-08 19:04
/usr/lib/libc-client.so -> libc-client.so.2002d
-rwxr-xr-x1 root root 770436 2003-09-23 14:29
/usr/lib/libc-client.so.2002d
Configure command: ./configure '--disable-shared'
'--with-mysqld-ldflags=-all-static' '--with-client-ldflags=-all-static'
'--with-server-suffix=-standard' '--without-embedded-server'
'--without-berkeley-db' '--with-innodb' '--without-vio' '--without-openssl'
'--enable-assembler' '--enable-local-infile' '--with-mysqld-user=mysql'
'--with-unix-socket-path=/var/lib/mysql/mysql.sock' '--prefix=/'
'--with-extra-charsets=complex' '--exec-prefix=/usr'
'--libexecdir=/usr/sbin' '--libdir=/usr/lib' '--sysconfdir=/etc'
'--datadir=/usr/share' '--localstatedir=/var/lib/mysql'
'--infodir=/usr/share/info' '--includedir=/usr/include'
'--mandir=/usr/share/man' '--enable-thread-safe-client'
'--with-comment=Official MySQL RPM' 'CC=' 'CFLAGS=-O2 -mcpu=i486
-fno-strength-reduce' 'CXXFLAGS=-O2 -mcpu=i486 -fno-
Re: [mysql] Dump table _files_ to a text file?
I tried doing this when I first got MySQL installed on the new machine, but when I did "SHOW DATABASES;" through mysql it was not listed. Is there something I need to do to let MySQL know that the database is there? Ryan Sinnwell Regional IT Engineer The Weitz Company 515-698-4281 515-229-5517 (Cell) >>> robert_rowe <[EMAIL PROTECTED]> 1/7/2004 12:43:24 PM >>> Just copy the database folder to your new server. If they are not corrupt then they should be accessible from your new server. -- 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: [mysql] Dump table _files_ to a text file?
Just copy the database folder to your new server. If they are not corrupt then they should be accessible from your new server. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysql dump speed
On Thu, Sep 11, 2003 at 04:27:10PM -0400, Brent Baisley wrote: > Have tried using the --opt parameter on mysqldump? This is supposed > optimize the dump speed and create a file optimized for reloading. I > haven't played with this option, so I don't know what kind of > difference it makes. It makes a very big difference. --opt tells mysqldump to use MySQL's extended insert syntax, so you're insering the data for many rows with a single query. That can often give you a speed boost of 10x or more. Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! <[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ MySQL 4.0.15-Yahoo-SMP: up 4 days, processed 168,707,245 queries (449/sec. avg) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: mysql dump speed
Use the --opt option when performing the dump. It can make a tremendous difference. -JF > -Original Message- > From: dan orlic [mailto:[EMAIL PROTECTED] > Sent: Thursday, September 11, 2003 12:31 PM > To: [EMAIL PROTECTED] > Subject: mysql dump speed > > > I have a bit of an issue with mysqldumps and inserting it back into > mysql. > > Granted, I have 1 table that has over 1Million entries, but generating > these tables takes about 3 hours with a java app. > But when I do a mysql -u root -p < it is taking > about 28 hours to complete the load. > > Can anyone tell me what is taking so long? Any thoughts as > how to speed > it up? Thanks in advance. > > > Dan orlic > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysql dump speed
Have tried using the --opt parameter on mysqldump? This is supposed optimize the dump speed and create a file optimized for reloading. I haven't played with this option, so I don't know what kind of difference it makes. On Thursday, September 11, 2003, at 03:30 PM, dan orlic wrote: I have a bit of an issue with mysqldumps and inserting it back into mysql. Granted, I have 1 table that has over 1Million entries, but generating these tables takes about 3 hours with a java app. But when I do a mysql -u root -p < it is taking about 28 hours to complete the load. Can anyone tell me what is taking so long? Any thoughts as how to speed it up? Thanks in advance. Dan orlic -- Brent Baisley Systems Architect Landover Associates, Inc. Search & Advisory Services for Advanced Technology Environments p: 212.759.6400/800.759.0577 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysql dump speed
Hi Dan, - Original Message - From: "dan orlic" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, September 11, 2003 2:30 PM Subject: mysql dump speed > I have a bit of an issue with mysqldumps and inserting it back into > mysql. > > Granted, I have 1 table that has over 1Million entries, but generating > these tables takes about 3 hours with a java app. > But when I do a mysql -u root -p < it is taking > about 28 hours to complete the load. > > Can anyone tell me what is taking so long? Any thoughts as how to speed > it up? Thanks in advance. Was the dump done using the --opt option with mysqldump? This should make reloading faster. What options *were* used? How is your application doing INSERTs? LOCK TABLES and/or multi-line INSERT statements? Is it a MyISAM table? If it's InnoDB, I think you'll need to do the INSERTs in one transaction to get more speed. Maybe your app does this and mysqldump isn't. Just some thoughts. :-) Hope that helps. Matt -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysql dump for remote db
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Mark -- ...and then Mark Stringham said... % % Well it looks like I have limited options. Yep. Hey, you could always host with me ;-) % % I'm guessing that the web host will let me have limited rights to the % server as it is - probably only basic FTP and other limited DB rights - % I do hve some control using phpmyadmin to manipulate data. OK. If I were you I'd just try a quick test. Whip up a php page that says \n\n" ; print_r($results) ; print "\n" ; print "exit code was '$exit'\n" ; ?> and see what you get. If it works, whip up another about like \n\n" . print_r($results) . "\n" ; print "exit code was '$exit'\n" ; ?> with USER, PASS, and DATABASE set accordingly (and you should check the mysqldump grammar; this is all right off the top of my head) and if it doesn't try any of system, `` or popen. % % I'll almost bet that they won't let me run a task from the server. % What about running a script from an exe ? What script, what exe, and what machine? % % thanks Sure thing! % % MS mysql query, :-D - -- David T-G * There is too much animal courage in (play) [EMAIL PROTECTED] * society and not sufficient moral courage. (work) [EMAIL PROTECTED] -- Mary Baker Eddy, "Science and Health" http://justpickone.org/davidtg/ Shpx gur Pbzzhavpngvbaf Qrprapl Npg! -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.7 (FreeBSD) iD8DBQE+OEx9Gb7uCXufRwARAod+AKDaV3f6KSh2eT7zuvIy3gn/osAV6QCgv160 rlm+atsvuT22qIj4fZEKId4= =0Umb -END PGP SIGNATURE- - 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
Re: mysql dump for remote db
Well it looks like I have limited options. I'm guessing that the web host will let me have limited rights to the server as it is - probably only basic FTP and other limited DB rights - I do hve some control using phpmyadmin to manipulate data. I'll almost bet that they won't let me run a task from the server. What about running a script from an exe ? thanks MS > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > Mark -- > > ...and then Mark Stringham said... > % > % Does anyone have a suggestion as to how I could run a periodic mysql dump > % for a db that is hosted remotely - IE a web host. I do know that this host > % does not support crons. > > Do you want it dumped on that machine or across to another machine? Is > there a web server on that machine? > > You've gotten a number of answers that will dump the database across the > network. If you want it locally and have a web server, write a little > php or perl script which will do the dump and then hit that page from any > other machine that has cron or task scheduler or whatnot. > > Meanwhile, start shopping around for other hosts that let you use cron :-) > > > % > % Any help is appreciated. > % > % thanks > > HTH & HAND > > > % > % MS > > > mysql query, > :-D > - -- > David T-G * There is too much animal courage in > (play) [EMAIL PROTECTED] * society and not sufficient moral courage. > (work) [EMAIL PROTECTED] -- Mary Baker Eddy, "Science and Health" > http://justpickone.org/davidtg/ Shpx gur Pbzzhavpngvbaf Qrprapl Npg! > > -BEGIN PGP SIGNATURE- > Version: GnuPG v1.0.7 (FreeBSD) > > iD8DBQE+N+AyGb7uCXufRwARAuwUAKC2pD4LcRul/lsr/apSeMDw3Q/NSwCffDoy > 7gpmgG0uOrRu5CRM8NnKSfM= > =nxjf > -END PGP SIGNATURE- > > - > 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 > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > Mark Stringham edea solutions 801.808.8791 - 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
Re: mysql dump for remote db
Well it looks like I have limited options. I'm guessing that the web host will let me have limited rights to the server as it is - probably only basic FTP and other limited DB rights - I do hve some control using phpmyadmin to manipulate data. I'll almost bet that they won't let me run a task from the server. What about running a script from an exe ? thanks MS > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > Mark -- > > ...and then Mark Stringham said... > % > % Does anyone have a suggestion as to how I could run a periodic mysql dump > % for a db that is hosted remotely - IE a web host. I do know that this host > % does not support crons. > > Do you want it dumped on that machine or across to another machine? Is > there a web server on that machine? > > You've gotten a number of answers that will dump the database across the > network. If you want it locally and have a web server, write a little > php or perl script which will do the dump and then hit that page from any > other machine that has cron or task scheduler or whatnot. > > Meanwhile, start shopping around for other hosts that let you use cron :-) > > > % > % Any help is appreciated. > % > % thanks > > HTH & HAND > > > % > % MS > > > mysql query, > :-D > - -- > David T-G * There is too much animal courage in > (play) [EMAIL PROTECTED] * society and not sufficient moral courage. > (work) [EMAIL PROTECTED] -- Mary Baker Eddy, "Science and Health" > http://justpickone.org/davidtg/ Shpx gur Pbzzhavpngvbaf Qrprapl Npg! > > -BEGIN PGP SIGNATURE- > Version: GnuPG v1.0.7 (FreeBSD) > > iD8DBQE+N+AyGb7uCXufRwARAuwUAKC2pD4LcRul/lsr/apSeMDw3Q/NSwCffDoy > 7gpmgG0uOrRu5CRM8NnKSfM= > =nxjf > -END PGP SIGNATURE- > > - > 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 > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > Mark Stringham edea solutions 801.808.8791 - 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
Re: mysql dump for remote db
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Mark -- ...and then Mark Stringham said... % % Does anyone have a suggestion as to how I could run a periodic mysql dump % for a db that is hosted remotely - IE a web host. I do know that this host % does not support crons. Do you want it dumped on that machine or across to another machine? Is there a web server on that machine? You've gotten a number of answers that will dump the database across the network. If you want it locally and have a web server, write a little php or perl script which will do the dump and then hit that page from any other machine that has cron or task scheduler or whatnot. Meanwhile, start shopping around for other hosts that let you use cron :-) % % Any help is appreciated. % % thanks HTH & HAND % % MS mysql query, :-D - -- David T-G * There is too much animal courage in (play) [EMAIL PROTECTED] * society and not sufficient moral courage. (work) [EMAIL PROTECTED] -- Mary Baker Eddy, "Science and Health" http://justpickone.org/davidtg/ Shpx gur Pbzzhavpngvbaf Qrprapl Npg! -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.7 (FreeBSD) iD8DBQE+N+AyGb7uCXufRwARAuwUAKC2pD4LcRul/lsr/apSeMDw3Q/NSwCffDoy 7gpmgG0uOrRu5CRM8NnKSfM= =nxjf -END PGP SIGNATURE- - 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
Re: mysql dump for remote db
Please don't hijack threads. In the last episode (Jan 28), Mark Stringham said: > Does anyone have a suggestion as to how I could run a periodic mysql > dump for a db that is hosted remotely - IE a web host. I do know that > this host does not support crons. Just cron "mysqldump -h webhostmachine" from another machine. -- Dan Nelson [EMAIL PROTECTED] sql query - 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
Re: mysql dump for remote db
On Tue, Jan 28, 2003 at 10:19:19AM -0700, Mark Stringham wrote: > Does anyone have a suggestion as to how I could run a periodic mysql dump > for a db that is hosted remotely - IE a web host. I do know that this host > does not support crons. > > Any help is appreciated. If you have access to a host that runs cron, run mysqldump with the -h option. i.e. mysqldump -hmysql.example.com -usomeuser -p database name Cheers! -- Zak Greant <[EMAIL PROTECTED]> | MySQL Advocate | http://zak.fooassociates.com Using and Managing MySQL MySQL Training: Stockholm, February 24-28, 2003 Visit http://mysql.com/training for more information Sincere Choice: Supporting a Fair Software Market (http://sincerechoice.org) - 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
Re: mysql dump for remote db
The biggest problem is if you want to do this from a remote pc, that pc will need access to the server itself and the mysql client tools. It sounds as if this pc is not on your LAN and I doubt the hosting service will be willing to expose there database to the internet so you can do a backup. If you do have access to the db from your computer you should be able to schedule something as simple as: mysqldum -u -p -h > to do your backup. Other then that I'm not sure how you could do this since you already stated your service wont schedule cron jobs. -Nick Mark Stringham said: > Does anyone have a suggestion as to how I could run a periodic mysql > dump for a db that is hosted remotely - IE a web host. I do know that > this host does not support crons. > > Any help is appreciated. > > thanks > > MS > > sql, query > > > - 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
Re: mysql dump not working
At 16:27 -0700 1/17/03, Zak Greant wrote: On Fri, Jan 17, 2003 at 04:24:37PM -0700, Mark Stringham wrote: I'm not sure what you mean but the file gets created and when I open it - there is nothing in it. Do I need the path to mysql at the beginning ? IE c:\apache\mysql\bin>mysqldump ? Hi Mark, To rephrase: If you run the command mysqldump -u uipcontent -p test on the command line, what happens? It'll probably say that the database "" does not exist. :-) Don't put a space between -p and the password . Cheers! -- Zak Greant <[EMAIL PROTECTED]> | MySQL Advocate | http://zak.fooassociates.com Developing Dynamic Web Applications with MySQL and PHP MySQL Training: Houston, February 17-21, 2003 Visit http://mysql.com/training for more information Open Source Initiative (http://www.opensource.org) - 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
Re: mysql dump not working
On Fri, Jan 17, 2003 at 04:12:58PM -0700, Mark Stringham wrote: > sql, query > > I'm trying to utilize the mysqldump utility to backup my db on a WIN2k > advanced server. I'm running a BAT file with the following syntax > > c:\apache\mysql\bin>mysqldump -u uipcontent -p test > > c:\testdump.sql > > the file testdump.sql gets created in the appropriate place but the > file itself has nothing in it. > > I'm obviously missing something. Do you see any output when you run mysqldump without redirecting stdout? -- Zak Greant <[EMAIL PROTECTED]> | MySQL Advocate | http://zak.fooassociates.com Managing MySQL MySQL Training: Washington DC, March 19-21, 2003 Visit http://mysql.com/training for more information Support Global Human Rights - Amnesty International (http://amnesty.org) - 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
Re: mysql dump not working
On Fri, Jan 17, 2003 at 04:24:37PM -0700, Mark Stringham wrote: > I'm not sure what you mean but the file gets created and when I open > it - there is nothing in it. > > Do I need the path to mysql at the beginning ? IE > c:\apache\mysql\bin>mysqldump ? Hi Mark, To rephrase: If you run the command mysqldump -u uipcontent -p test on the command line, what happens? Cheers! -- Zak Greant <[EMAIL PROTECTED]> | MySQL Advocate | http://zak.fooassociates.com Developing Dynamic Web Applications with MySQL and PHP MySQL Training: Houston, February 17-21, 2003 Visit http://mysql.com/training for more information Open Source Initiative (http://www.opensource.org) - 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
Re: mysql dump not working
I'm not sure what you mean but the file gets created and when I open it - there is nothing in it. Do I need the path to mysql at the beginning ? IE c:\apache\mysql\bin>mysqldump ? thanks MS > On Fri, Jan 17, 2003 at 04:12:58PM -0700, Mark Stringham wrote: > > sql, query > > > > I'm trying to utilize the mysqldump utility to backup my db on a WIN2k > > advanced server. I'm running a BAT file with the following syntax > > > > c:\apache\mysql\bin>mysqldump -u uipcontent -p test > > > c:\testdump.sql > > > > the file testdump.sql gets created in the appropriate place but the > > file itself has nothing in it. > > > > I'm obviously missing something. > > Do you see any output when you run mysqldump without redirecting > stdout? > > -- > Zak Greant <[EMAIL PROTECTED]> | MySQL Advocate | http://zak.fooassociates.com > > Managing MySQL > MySQL Training: Washington DC, March 19-21, 2003 > Visit http://mysql.com/training for more information > > Support Global Human Rights - Amnesty International (http://amnesty.org) > > Mark Stringham edea solutions 801.808.8791 - 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
Re: mysql dump not working
I'm not sure what you mean but the file gets created and when I open it - there is nothing in it. Do I need the path to mysql at the beginning ? IE c:\apache\mysql\bin>mysqldump ? thanks MS > On Fri, Jan 17, 2003 at 04:12:58PM -0700, Mark Stringham wrote: > > sql, query > > > > I'm trying to utilize the mysqldump utility to backup my db on a WIN2k > > advanced server. I'm running a BAT file with the following syntax > > > > c:\apache\mysql\bin>mysqldump -u uipcontent -p test > > > c:\testdump.sql > > > > the file testdump.sql gets created in the appropriate place but the > > file itself has nothing in it. > > > > I'm obviously missing something. > > Do you see any output when you run mysqldump without redirecting > stdout? > > -- > Zak Greant <[EMAIL PROTECTED]> | MySQL Advocate | http://zak.fooassociates.com > > Managing MySQL > MySQL Training: Washington DC, March 19-21, 2003 > Visit http://mysql.com/training for more information > > Support Global Human Rights - Amnesty International (http://amnesty.org) > > Mark Stringham edea solutions 801.808.8791 - 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
re: Mysql dump error
Dan, Thursday, November 07, 2002, 9:11:10 AM, you wrote: DR> mysqldump: Got error: 1030: Got error 127 from table handler when retrieving DR> data DR> from server DR> for some reason i get this when i dump all databases DR> using mysqldump -p --all-databases --add-drop-table --quote-names > DR> all_databases.sql Error 127 means that record file is crashed. Repair table with myisamchk or REPAIR TABLE: http://www.mysql.com/doc/en/Repair.html -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.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
RE: Mysql dump error
ok i found the troubled table DROP TABLE IF EXISTS `activity`; CREATE TABLE `activity` ( `int_activity_id` int(11) NOT NULL auto_increment, `vch_uniqid` varchar(50) NOT NULL default '', `int_user_id` int(11) NOT NULL default '0', `ts_time` int(50) NOT NULL default '0', `vch_page_viewed` varchar(255) NOT NULL default '', PRIMARY KEY (`int_activity_id`), UNIQUE KEY `int_activity_id` (`int_activity_id`), KEY `vch_uniqid` (`vch_uniqid`) ) TYPE=MyISAM; wot could be the prob ? -Original Message- From: Dan Rossi [mailto:daniel@;electroteque.org] Sent: Thursday, November 07, 2002 6:11 PM To: MySQL Mailing List Subject: Mysql dump error mysqldump: Got error: 1030: Got error 127 from table handler when retrieving data from server for some reason i get this when i dump all databases using mysqldump -p --all-databases --add-drop-table --quote-names > all_databases.sql - 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
Re: MySQL dump/recovery probable bug
Hi! > "Georg" == Georg Richter <[EMAIL PROTECTED]> writes: Georg> On Friday, 21. June 2002 15:43, Stefano Incontri wrote: Georg> Hi, >> >> I found the following problem, which I consider a bug, but maybe I'm >> missing something to make it work correctly. Georg> This is not a bug. Why do you use a reserved word (LOAD) for an index name?! Georg> Rename it and everything should be ok. Georg> See also: http://www.mysql.com/doc/R/e/Reserved_words.html Another option is to use the mysqld option --quote-names. Regards, Monty -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Michael Widenius <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, CTO /_/ /_/\_, /___/\___\_\___/ Helsinki, Finland <___/ www.mysql.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
Re: MySQL dump/recovery probable bug
On Friday, 21. June 2002 15:43, Stefano Incontri wrote: Hi, > > I found the following problem, which I consider a bug, but maybe I'm > missing something to make it work correctly. This is not a bug. Why do you use a reserved word (LOAD) for an index name?! Rename it and everything should be ok. See also: http://www.mysql.com/doc/R/e/Reserved_words.html Regards Georg - 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
RE: MySQL dump/recovery - no bug at all
Thank you very much for your quick and accurate responses.
I tried to dump with the -Q (--quote-names) and it perfectly works.
I'm not completely sure I understood what Tod Harter meant in his mail,
because I set up an 'automated' backup process, and if I would ever need
to recovery our main DB, I would not like to manually edit the SQL
script generated by mysqldump, so I can't remove indexes creation before
uploading data.
My only doubt remains if there could ever be any concern about quoting
names while dumping; I mean, if not, why don't setting it as the
default?
Anyway thank you very much again, the problem is solved.
Regards,
Stefano
> -Original Message-
> From: Victoria Reznichenko [mailto:[EMAIL PROTECTED]]
> Sent: 21 June 2002 16:31
> To: [EMAIL PROTECTED]
> Subject: Re: MySQL dump/recovery probable bug
>
>
> Stefano,
> Friday, June 21, 2002, 4:43:29 PM, you wrote:
>
> SI> I found the following problem, which I consider a bug,
> but maybe I'm missing something to make it work correctly.
>
> SI> I'm using 'mysqldump' to backup our MySQL DB, and when I
> try to recover it on a blank DB it gives syntax errors while
> creating some table.
> SI> This is the Table structure which cause the error :
>
> [skip]
>
> SI> When I try to run this command on the mysql console, I
> receive the following error :
> SI> mysql> CREATE TABLE Test (
> SI> -> ID int(10) unsigned NOT NULL auto_increment,
> SI> -> IL varchar(12) NOT NULL default '',
> SI> -> Item_ID int(10) unsigned NOT NULL default '0',
> SI> -> BLDate datetime NOT NULL default '-00-00 00:00:00',
> SI> -> RelToTest datetime default NULL,
> SI> -> RelToRegr datetime default NULL,
> SI> -> RelToNPI datetime default NULL,
> SI> -> RelToCCO datetime default NULL,
> SI> -> SanityResult enum('None','Green','Red') NOT NULL
> default 'None',
> SI> -> PRIMARY KEY (ID),
> SI> -> UNIQUE KEY Load (IL,Item_ID)
> SI> -> ) TYPE=MyISAM COMMENT='SCM Internal Loads table';
> SI> ERROR 1064: You have an error in your SQL syntax near
> 'Load (IL,Item_ID)
> SI> ) TYPE=MyISAM COMMENT='SCM Internal Loads table'' at line 12
>
> [skip]
>
> SI> Is really urgent for us to solve this problem, because
> our DB is growing fast and we would like to have a consistent Backup.
> SI> If I'm doing something wrong, please tell me.
>
> LOAD is a reserved word:
> http://www.mysql.com/doc/R/e/Reserved_words.html
>
> It's not recommended to use reserved words in table/column/key etc
> names...
> You can fix you problem just quoting LOAD with a ``' characters. Use
> -Q or --quote-names option of mysqldump.
>
> SI> Best Regards,
> SI> Stefano
>
>
>
>
> --
> For technical support contracts, goto
> https://order.mysql.com/?ref=ensita
> This email is sponsored
> by Ensita.net http://www.ensita.net/
>__ ___ ___ __
> / |/ /_ __/ __/ __ \/ /Victoria Reznichenko
> / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
> /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net
><___/ www.mysql.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
Re: MySQL dump/recovery probable bug
On Friday 21 June 2002 09:54, Keith C. Ivey wrote: > On 21 Jun 2002, at 15:43, Stefano Incontri wrote: > > ERROR 1064: You have an error in your SQL syntax near 'Load (IL,Item_ID) > > ) TYPE=MyISAM COMMENT='SCM Internal Loads table'' at line 12 > > "LOAD" is a reserved word in MySQL, so you need backticks around it. > Have you tried using the --quote-names option in mysqldump? > > http://www.mysql.com/doc/m/y/mysqldump.html On top of what Keith says, it is a lot more efficient to create the index AFTER you load the data anyway. Given that the data is a restore of known-good values which shouldn't ever violate the unique key constraint there is no advantage in creating the index before loading. With large amounts of data the difference in performance could be considerable. I'm only working from memory here, but I think there are also some parameters related to transactions and InnoDB tables you want to look at as well when you load up large amounts of data. - 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
Re: MySQL dump/recovery probable bug
Stefano,
Friday, June 21, 2002, 4:43:29 PM, you wrote:
SI> I found the following problem, which I consider a bug, but maybe I'm missing
something to make it work correctly.
SI> I'm using 'mysqldump' to backup our MySQL DB, and when I try to recover it on a
blank DB it gives syntax errors while creating some table.
SI> This is the Table structure which cause the error :
[skip]
SI> When I try to run this command on the mysql console, I receive the following error
:
SI> mysql> CREATE TABLE Test (
SI> -> ID int(10) unsigned NOT NULL auto_increment,
SI> -> IL varchar(12) NOT NULL default '',
SI> -> Item_ID int(10) unsigned NOT NULL default '0',
SI> -> BLDate datetime NOT NULL default '-00-00 00:00:00',
SI> -> RelToTest datetime default NULL,
SI> -> RelToRegr datetime default NULL,
SI> -> RelToNPI datetime default NULL,
SI> -> RelToCCO datetime default NULL,
SI> -> SanityResult enum('None','Green','Red') NOT NULL default 'None',
SI> -> PRIMARY KEY (ID),
SI> -> UNIQUE KEY Load (IL,Item_ID)
SI> -> ) TYPE=MyISAM COMMENT='SCM Internal Loads table';
SI> ERROR 1064: You have an error in your SQL syntax near 'Load (IL,Item_ID)
SI> ) TYPE=MyISAM COMMENT='SCM Internal Loads table'' at line 12
[skip]
SI> Is really urgent for us to solve this problem, because our DB is growing fast and
we would like to have a consistent Backup.
SI> If I'm doing something wrong, please tell me.
LOAD is a reserved word:
http://www.mysql.com/doc/R/e/Reserved_words.html
It's not recommended to use reserved words in table/column/key etc
names...
You can fix you problem just quoting LOAD with a ``' characters. Use
-Q or --quote-names option of mysqldump.
SI> Best Regards,
SI> Stefano
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Victoria Reznichenko
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net
<___/ www.mysql.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
Re: MySQL dump/recovery probable bug
On 21 Jun 2002, at 15:43, Stefano Incontri wrote: > ERROR 1064: You have an error in your SQL syntax near 'Load (IL,Item_ID) > ) TYPE=MyISAM COMMENT='SCM Internal Loads table'' at line 12 "LOAD" is a reserved word in MySQL, so you need backticks around it. Have you tried using the --quote-names option in mysqldump? http://www.mysql.com/doc/m/y/mysqldump.html -- Keith C. Ivey <[EMAIL PROTECTED]> Tobacco Documents Online http://tobaccodocuments.org - 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
RE: mySQL "dump"
* On-Site > I'm very new to mySQL and have what is probably a simple question. I've > created my database using mySQL and it resides on my local PC. I want to > upload it to my hosting service's server. > > They tell me "You would dump the content of your mysql database on your > local machine and then use the mysql admin section we provide inside your > member services section to import that content to your server database." > > I've looked for a "dump" type command and can't locate anything nor > export/import. Can someone tell me how to go about getting my database > loaded onto my hosting service's server. They support mySQL. There is a utility called 'mysqldump' in your mysql\bin directory. http://www.mysql.com/doc/m/y/mysqldump.html > -- Roger - 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
Re: Mysql dump
Uma Shankari T queried: > I am having all mysql database contents in one txt file.how i will dump > all those contents to mysql database tablespls tell me how to do it Have you looked at the manual, section 4.8.7? mysqlimport Joel Rees Alps Giken Kansai Systems Develoment Suita, Osaka - 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
Re: Mysql Dump
on 3/13/01 12:41 AM, Gilles Dumangin at [EMAIL PROTECTED] wrote: > I would like to extract the contents of a database to use it in a ASCII > format. It is a addresses database and I want to use it in Excel. I have > tried Mysqldump but it gives me the CREATE and INSERT statements all the > time. SELECT ... INTO OUTFILE Will put the data into the file specified in a tab seperated text format. There are other options detailed in the manual. Bear in mind that the file is placed on the server, not the client, and that mysqld must have write permission on the directory you're putting it in. Hope this helps, Geoff - 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
RE: Mysql Dump
That's what mysqldump does. Try using a SELECT statement with an outfile. Check the manual, chapter 7, the part about SELECT for details. Cal http://www.calevans.com -Original Message- From: Gilles Dumangin [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 13, 2001 1:42 AM To: [EMAIL PROTECTED] Subject: Mysql Dump Hi, I would like to extract the contents of a database to use it in a ASCII format. It is a addresses database and I want to use it in Excel. I have tried Mysqldump but it gives me the CREATE and INSERT statements all the time. Any ideas? Gilles _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.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
