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 > >
mysql dump global read lock
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: Recovery from a MySQL dump is too long !
Am 14.08.2012 09:42, schrieb Bob Sauvage: > Hello *, > > My INNODB database has a size of 80GO. I've a replication setup on 3 slaves > and I backup my db from them. > If a problem occurs on the database, a recovery from a dump takes around 6H ! > That's too long for us. > > 2 ideas : > 1. Stop the slave and rsync the folder /var/lib/mysql to another server > 2. Stop the slave, take a dump and when it's finish, pull the dump in another > MySQL instance daily. i do the stop slave and rsync data-dir since many years over WAN connections for offsite backups, never was a friend of dumping databases to textfiles if something is damaged due a power-interruption this is also the fastest restore because rsync is much faster even with --checksums as any dump signature.asc Description: OpenPGP digital signature
Recovery from a MySQL dump is too long !
Hello *, My INNODB database has a size of 80GO. I've a replication setup on 3 slaves and I backup my db from them. If a problem occurs on the database, a recovery from a dump takes around 6H ! That's too long for us. 2 ideas : 1. Stop the slave and rsync the folder /var/lib/mysql to another server 2. Stop the slave, take a dump and when it's finish, pull the dump in another MySQL instance daily. Do you have another ideas ? What's your advices ? Thanks in advance,
Re: Duplicate key name when importing mysql dump file
Hi Jason, You may have to run "ANALYZE TABLE.." for the particular table for which you are facing the error. So it'll rebuild the indexes. This would be the best one to save your data. We can use the method which Mr.Isart suggested, but it'll ignore the error and also will lead to data loss. Regards, Vinodh.k On Sat, Jun 20, 2009 at 12:19 AM, Isart Montane wrote: > Hi Jason, > > if you run mysql with -f it will ignore any errors and continue importing > > cat aac.sql | mysql -f -u root AAC > > Isart > > On Wed, Jun 17, 2009 at 8:59 PM, Jason Novotny >wrote: > > > Hi, > > > > I'm trying to import a dumpfile like so: > > > > cat aac.sql | mysql -u root AAC > > > > It all runs fine until I get something like: > > > > ERROR 1061 (42000) at line 5671: Duplicate key name > 'FK_mediaZip_to_zipSet' > > > > > > Is there a way I can tell it to ignore or replace the key? > > > > Thanks, Jason > > > > -- > > MySQL General Mailing List > > For list archives: http://lists.mysql.com/mysql > > To unsubscribe: > > http://lists.mysql.com/mysql?unsub=isart.mont...@gmail.com > > > > >
Re: Duplicate key name when importing mysql dump file
Hi Jason, if you run mysql with -f it will ignore any errors and continue importing cat aac.sql | mysql -f -u root AAC Isart On Wed, Jun 17, 2009 at 8:59 PM, Jason Novotny wrote: > Hi, > > I'm trying to import a dumpfile like so: > > cat aac.sql | mysql -u root AAC > > It all runs fine until I get something like: > > ERROR 1061 (42000) at line 5671: Duplicate key name 'FK_mediaZip_to_zipSet' > > > Is there a way I can tell it to ignore or replace the key? > > Thanks, Jason > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/mysql?unsub=isart.mont...@gmail.com > >
Duplicate key name when importing mysql dump file
Hi, I'm trying to import a dumpfile like so: cat aac.sql | mysql -u root AAC It all runs fine until I get something like: ERROR 1061 (42000) at line 5671: Duplicate key name 'FK_mediaZip_to_zipSet' Is there a way I can tell it to ignore or replace the key? Thanks, Jason -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: If I use iconv to convert mysql dump data file with some blob field then blob binary data will be corrupted ?
Le Tue, 23 Dec 2008 15:33:34 +, KLEIN Stéphane a écrit : > Le Tue, 23 Dec 2008 14:42:40 +, KLEIN Stéphane a écrit : > >> Hi, >> >> This my script to convert latin1 database to utf8 : >> >> $ mysqldump --user=root --password=password --host=mybox mydatabase -- >> default-character-set=latin1 > mydatabase.latin1.sql$ mysqldump -- >> user=root --password=password --host=mybox mydatabase >> --default-character- set=latin1 > mydatabase.latin1.sql $ sed -e >> 's/latin1/utf8/g' mydatabase.latin1.sql > mydatabase.utf8.sql $ iconv >> -f latin1 -t utf8 mydatabase.utf8.sql > mydatabase.utf8.sql $ echo "SET >> NAMES utf8;" > tmp.sql >> $ cat mydatabase.utf8.sql >> tmp.sql >> $ mv tmp.sql mydatabase.utf8.sql >> >> I've one question : >> >> * if my database have some blob field with binary data (like image...), >> iconv convert also this data then this data will be corrupted ? > > I've the answer ! > > My previous script corrupt binary data. > > To fix this issue I need to dump data with --hex-dump option : > > $ mysqldump --hex-dump --user=root --password=password --host=mybox > mydatabase --default-character-set=latin1 > mydatabase.latin1.sql$ > mysqldump --user=root --password=password --host=mybox mydatabase Sorry, it's --hex-blob not --hex-dump $ mysqldump --hex-blob --user=root --password=password --host=mybox mydatabase --default-character-set=latin1 > mydatabase.latin1.sql Regards, Stephane -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: If I use iconv to convert mysql dump data file with some blob field then blob binary data will be corrupted ?
Le Tue, 23 Dec 2008 14:42:40 +, KLEIN Stéphane a écrit : > Hi, > > This my script to convert latin1 database to utf8 : > > $ mysqldump --user=root --password=password --host=mybox mydatabase -- > default-character-set=latin1 > mydatabase.latin1.sql$ mysqldump -- > user=root --password=password --host=mybox mydatabase > --default-character- set=latin1 > mydatabase.latin1.sql > $ sed -e 's/latin1/utf8/g' mydatabase.latin1.sql > mydatabase.utf8.sql $ > iconv -f latin1 -t utf8 mydatabase.utf8.sql > mydatabase.utf8.sql $ echo > "SET NAMES utf8;" > tmp.sql > $ cat mydatabase.utf8.sql >> tmp.sql > $ mv tmp.sql mydatabase.utf8.sql > > I've one question : > > * if my database have some blob field with binary data (like image...), > iconv convert also this data then this data will be corrupted ? I've the answer ! My previous script corrupt binary data. To fix this issue I need to dump data with --hex-dump option : $ mysqldump --hex-dump --user=root --password=password --host=mybox mydatabase --default-character-set=latin1 > mydatabase.latin1.sql$ mysqldump --user=root --password=password --host=mybox mydatabase Regards, Stephane -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: If I use iconv to convert mysql dump data file with some blob field then blob binary data will be corrupted ?
I've break line misteak in my previous message, this is the fix : $ mysqldump --user=root --password=password --host=mybox mydatabase -- default-character-set=latin1 > mydatabase.latin1.sql$ mysqldump -- user=root --password=password --host=mybox mydatabase --default-character- set=latin1 > mydatabase.latin1.sql $ sed -e 's/latin1/utf8/g' mydatabase.latin1.sql > mydatabase.utf8.sql $ iconv -f latin1 -t utf8 mydatabase.utf8.sql > mydatabase.utf8.sql $ echo > "SET NAMES utf8;" > tmp.sql $ cat mydatabase.utf8.sql >> tmp.sql $ mv tmp.sql mydatabase.utf8.sql Regards, Stephane -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
If I use iconv to convert mysql dump data file with some blob field then blob binary data will be corrupted ?
Hi, This my script to convert latin1 database to utf8 : $ mysqldump --user=root --password=password --host=mybox mydatabase -- default-character-set=latin1 > mydatabase.latin1.sql$ mysqldump -- user=root --password=password --host=mybox mydatabase --default-character- set=latin1 > mydatabase.latin1.sql $ sed -e 's/latin1/utf8/g' mydatabase.latin1.sql > mydatabase.utf8.sql $ iconv -f latin1 -t utf8 mydatabase.utf8.sql > mydatabase.utf8.sql $ echo "SET NAMES utf8;" > tmp.sql $ cat mydatabase.utf8.sql >> tmp.sql $ mv tmp.sql mydatabase.utf8.sql I've one question : * if my database have some blob field with binary data (like image...), iconv convert also this data then this data will be corrupted ? Thanks for your information, Stephane -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
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
mysql dump problems, no data dumped
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.
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]
mysql dump
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
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]
mysql dump
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 -- 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]
mysql dump help!
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]
mysql dump restore.
Hi All, I have a mysqldump take from machine A on 14th July,2007. When i took the mysqldump the bin-log file name postion was Master_Log_File: mysql-bin.34 Read_Master_Log_Pos: 155537266. Now i have restored this dump into another machine B which already had log_bin enabled. Its current bin-log file name and position is as below File: mysql-bin.87 Position: 417737430. Now if i want to get this machine B in sync with the machine A, how do i apply the bin-log at regular frequency, because, the bin-log file name in machine B is different from machine A. Please help. regards anandkl
Re: Restoring a database from a complete MySQL dump
You should be able to pull each table (create + inserts) out into a stand alone file table1.sql table2.sql etc... and then you can restore table by table. This might be harder depending on the size of your database tables. If you have a million rows, chances are your .sql file is huge and it would require a pretty robust text editor that could handle such a big file. In vi you could just locate the 1st line of the CREATE and the last line of the last insert (before the next create) and then do : 1,100 w table1.sql - Original Message - From: "kent stand" <[EMAIL PROTECTED]> To: Sent: Wednesday, March 08, 2006 1:17 PM Subject: Restoring a database from a complete MySQL dump I have a MySQL 4.1.x installation. It was upgraded to MySQL 5.0.x and then downgraded again, back to 4.1.14. I took a complete dump of all databases/tables into a .sql file, and now I would like to restore just specific databases or tables from it. Is this possible without restoring everything or without having to restore everything somewhere else, and then make new back-ups of the specific tables/databases? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Restoring a database from a complete MySQL dump
I have a MySQL 4.1.x installation. It was upgraded to MySQL 5.0.x and then downgraded again, back to 4.1.14. I took a complete dump of all databases/tables into a .sql file, and now I would like to restore just specific databases or tables from it. Is this possible without restoring everything or without having to restore everything somewhere else, and then make new back-ups of the specific tables/databases?
RE: Restoring mySQL dump
[snip] `user_id` mediumint(8) unsigned NOT NULL default '0', `group_id` mediumint(8) unsigned NOT NULL default '0', `quota_type` smallint(2) NOT NULL default '0', `quota_limit_id` mediumint(8) unsigned NOT NULL default '0', KEY `quota_type` (`quota_type`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; [/snip] [snip from earlier e-mail] The mySQL version is: 4.0.22 [/snip] Quote from http://dev.mysql.com/doc/mysql/en/create-table.html "As of MySQL 4.1, character column definitions can include a CHARACTER SET attribute to specify the character set and, optionally, a collation for the column. For details, see Chapter 10, Character Set Support. CHARSET is a synonym for CHARACTER SET. CREATE TABLE t (c CHAR(20) CHARACTER SET utf8 COLLATE utf8_bin);" CHARSET is not supported in your version of MySQL -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Restoring mySQL dump
Hello, None of these lines describe the problem that you are having with syntax. Can you give us 5 lines either side of the line that includes 'DEFAULT CHARSET=latin1'? Yes, here it is: `user_id` mediumint(8) unsigned NOT NULL default '0', `group_id` mediumint(8) unsigned NOT NULL default '0', `quota_type` smallint(2) NOT NULL default '0', `quota_limit_id` mediumint(8) unsigned NOT NULL default '0', KEY `quota_type` (`quota_type`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `db1_attach_quota` -- /*!4 ALTER TABLE `db1_attach_quota` DISABLE KEYS */; LOCK TABLES `db1_attach_quota` WRITE; UNLOCK TABLES; /*!4 ALTER TABLE `db1_attach_quota` ENABLE KEYS */; -- -- Table structure for table `db1_attachments` -- Thank you very much indeed. Best regards. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Restoring mySQL dump
[snip] Yes, here are the first 10 lines: -- MySQL dump 10.9 -- -- Host: localhostDatabase: account_databasename -- -- -- Server version 4.1.8-standard /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */; /*!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" */; ERROR 1064 at line 20: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'DEFAULT CHARSET=latin1' at line 7 [/snip] Can we see the first 10 lines of backupname.sql? Then maybe we can determine what the syntax error is that is NEAR line 7 [/snip] None of these lines describe the problem that you are having with syntax. Can you give us 5 lines either side of the line that includes 'DEFAULT CHARSET=latin1'? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Restoring mySQL dump
Hello, Yes, here are the first 10 lines: -- MySQL dump 10.9 -- -- Host: localhostDatabase: account_databasename -- -- -- Server version 4.1.8-standard /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */; /*!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" */; Thanks very much. Best regards, Adrian. [snip] mysql -u root -p dbname < backupname.sql And getting: ERROR 1064 at line 20: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'DEFAULT CHARSET=latin1' at line 7 [/snip] Can we see the first 10 lines of backupname.sql? Then maybe we can determine what the syntax error is that is NEAR line 7 -- 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: Restoring mySQL dump
[snip] mysql -u root -p dbname < backupname.sql And getting: ERROR 1064 at line 20: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'DEFAULT CHARSET=latin1' at line 7 [/snip] Can we see the first 10 lines of backupname.sql? Then maybe we can determine what the syntax error is that is NEAR line 7 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Restoring mySQL dump
Hi, I am now using the following: mysql -u root -p dbname < backupname.sql And getting: ERROR 1064 at line 20: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'DEFAULT CHARSET=latin1' at line 7 The mySQL version is: 4.0.22 And yes I can login to the mySQL command line with the root password. Any suggestions would be much appreciated. Thank you very much. Best regards. Can you sign -in as root user i.e. Administrator? Using: mysql -u username -p password? Dwayne Hottinger wrote: That is correct. The password for mysql root is probably not the same as the system root. ddh Quoting Adrian Cooper <[EMAIL PROTECTED]>: Hello, I need to restore a mySQL dump file but cannot find the right syntax. I have root access and have used: mysql -u root -p account_databasename < backupname But I am getting: Access denied for user '[EMAIL PROTECTED]' (Using password: YES) I have also removed the root password and got: Access denied for user '[EMAIL PROTECTED]' (Using password: No) What is the correct syntax please? Also, can I create a new database and restore the dump file to it or do I need to use the same database name as before? Thank you very much indeed. Best regards. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- Dwayne Hottinger Network Administrator Harrisonburg City Public Schools -- Kind Regards Schalk Neethling Web Developer.Designer.Programmer.President Volume4.Business.Solution.Developers emotionalize.conceptualize.visualize.realize Landlines Tel: +27125468436 Fax: +27125468436 Web email:[EMAIL PROTECTED] Global: www.volume4.com Messenger Yahoo!: v_olume4 AOL: v0lume4 MSN: [EMAIL PROTECTED] We support OpenSource Get Firefox!- The browser reloaded - http://www.mozilla.org/products/firefox/ This message contains information that is considered to be sensitive or confidential and may not be forwarded or disclosed to any other party without the permission of the sender. If you received this message in error, please notify me immediately so that I can correct and delete the original email. Thank you. -- 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: Restoring mySQL dump
Since I am on Windows, I prefer to use a GUI tool like SQLyog (www.webyog.com) Karam --- Adrian Cooper <[EMAIL PROTECTED]> wrote: > Hello, > > I need to restore a mySQL dump file but cannot find > the right syntax. > > I have root access and have used: > > mysql -u root -p account_databasename < backupname > > But I am getting: Access denied for user > '[EMAIL PROTECTED]' (Using password: > YES) > > I have also removed the root password and got: > Access denied for user > '[EMAIL PROTECTED]' (Using password: No) > > What is the correct syntax please? > > Also, can I create a new database and restore the > dump file to it or do I > need to use the same database name as before? > > Thank you very much indeed. > > Best regards. > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > Yahoo! Mail Stay connected, organized, and protected. Take the tour: http://tour.mail.yahoo.com/mailtour.html -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Restoring mySQL dump
Can you sign -in as root user i.e. Administrator? Using: mysql -u username -p password? Dwayne Hottinger wrote: That is correct. The password for mysql root is probably not the same as the system root. ddh Quoting Adrian Cooper <[EMAIL PROTECTED]>: Hello, I need to restore a mySQL dump file but cannot find the right syntax. I have root access and have used: mysql -u root -p account_databasename < backupname But I am getting: Access denied for user '[EMAIL PROTECTED]' (Using password: YES) I have also removed the root password and got: Access denied for user '[EMAIL PROTECTED]' (Using password: No) What is the correct syntax please? Also, can I create a new database and restore the dump file to it or do I need to use the same database name as before? Thank you very much indeed. Best regards. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- Dwayne Hottinger Network Administrator Harrisonburg City Public Schools -- Kind Regards Schalk Neethling Web Developer.Designer.Programmer.President Volume4.Business.Solution.Developers emotionalize.conceptualize.visualize.realize Landlines Tel: +27125468436 Fax: +27125468436 Web email:[EMAIL PROTECTED] Global: www.volume4.com Messenger Yahoo!: v_olume4 AOL: v0lume4 MSN: [EMAIL PROTECTED] We support OpenSource Get Firefox!- The browser reloaded - http://www.mozilla.org/products/firefox/ This message contains information that is considered to be sensitive or confidential and may not be forwarded or disclosed to any other party without the permission of the sender. If you received this message in error, please notify me immediately so that I can correct and delete the original email. Thank you. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Restoring mySQL dump
That is correct. The password for mysql root is probably not the same as the system root. ddh Quoting Adrian Cooper <[EMAIL PROTECTED]>: > Hello, > > I need to restore a mySQL dump file but cannot find the right syntax. > > I have root access and have used: > > mysql -u root -p account_databasename < backupname > > But I am getting: Access denied for user '[EMAIL PROTECTED]' (Using password: > YES) > > I have also removed the root password and got: Access denied for user > '[EMAIL PROTECTED]' (Using password: No) > > What is the correct syntax please? > > Also, can I create a new database and restore the dump file to it or do I > need to use the same database name as before? > > Thank you very much indeed. > > Best regards. > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > -- Dwayne Hottinger Network Administrator Harrisonburg City Public Schools -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Restoring mySQL dump
Hello, I need to restore a mySQL dump file but cannot find the right syntax. I have root access and have used: mysql -u root -p account_databasename < backupname But I am getting: Access denied for user '[EMAIL PROTECTED]' (Using password: YES) I have also removed the root password and got: Access denied for user '[EMAIL PROTECTED]' (Using password: No) What is the correct syntax please? Also, can I create a new database and restore the dump file to it or do I need to use the same database name as before? Thank you very much indeed. Best regards. -- 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]
MySQL dump (OT?)
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]
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
MYSQL DUMP FILES
Dear friends, I am using following command to dump mysql database files, mysql> mysqldump b -> c:/hdump/dump.sql where c:/hdump/dump.sql is the path where database files should be stored, however its not working. Any guidance, please.
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 > Configur
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
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' '--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-strength-reduce-felide-constructors -fno-exceptions -fno-rtti ' 'CXX=' -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
mysql dump file not completely importing
Hi, As my database has grown I have found that the dump isn't completely restoring to my development machine (XP Pro). The file is now up to about 30 MB but it only imports about half the tables. The command I'm using to restore the db is: d:\mysql\bin\mysql.exe -h localhost -u username -ppassword database < C:\file.sql Is there possible something in my ini that is limiting the size of input file? thanks in advance, Jeff Surcess [EMAIL PROTECTED] Mobile: 0414 887 100
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]
[mysql] Dump table _files_ to a text file?
I have a MySQL installation that went terribly wrong so I changed to a different server, reset everything up and am up and running again. The problem is, I'm so new to this I didn't know how to move my databases, and since there wasn't much information in them (about two weeks worth of posts to a phpBB), I just started from scratch with a new database. Is there a way I can access the .FRM, .MYD. and .MYI to dump the text to a text file of some sort? Is there any easy way to use these files and import them into Access 2003? Keep in mind that these files are not part of a working MySQL install, so I need a way to work with them that is not dependent upon the MySQL installation working. Thanks! Ryan Sinnwell Regional IT Engineer The Weitz Company 515-698-4281 515-229-5517 (Cell) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Like MySQL Dump, but with FoxPro Tables
On Monday, September 29, 2003, at 03:29 PM, Carlos Vazquez wrote:
I want to create an application that transfers data from FoxPro (*.dbf)
tables to MySQL. Does MySQL have a DUMP like or LOAD LIKE function
that
transfers this data in one step?
I just don't want to loop into thousands of records to insert them one
by one into my MySQL database. It makes my program too slow and very
unlikely to use...
You can use the SQL PassThrough features of Visual FoxPro to do this
quickly and easily. Create the table in MySQL with the same structure
as your Fox DBF. Then run the following code in Fox:
lnHandle = SQLCONNECT( [your connection info] )
lcSQL = "select * from mytable where 0"
* This will create an empty cursor with the structure you need
SQLEXEC(lnHandle, lcSQL, "crsMyTable")
* Make the cursor updatable
MakeUpdatable("mytable", "crsMyTable", 5, "idfield")
SELECT crsMyTable
APPEND FROM MyFoxTable.DBF
? TABLEUPDATE(.T.)
If all goes well, the last line should print ".T." on the Fox screen.
"MakeUpdatable" is a handy utility written by Paul McNett that
automatically does all the CURSORSETPROP calls for you. It is available
for free on my website: http://leafe.com/dls/vfp
___/
/
__/
/
/
Ed Leafe
http://leafe.com/
http://opentech.leafe.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Like MySQL Dump, but with FoxPro Tables
you can export the foxpro table to a text file and import to your mysql table. like this: mysql> SET AUTOCOMMIT=1; # Used for quick re-create of the table mysql> DELETE FROM pet; mysql> LOAD DATA LOCAL INFILE "pet.txt" INTO TABLE pet FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\r\n'; if there are many indexes, it's better to disable indexes, then enable them ALTER TABLE .. DISABLE KEYS ALTER TABLE .. ENABLE KEYS - Original Message - From: "Carlos Vazquez" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, September 29, 2003 3:29 PM Subject: Like MySQL Dump, but with FoxPro Tables Hi all! I want to create an application that transfers data from FoxPro (*.dbf) tables to MySQL. Does MySQL have a DUMP like or LOAD LIKE function that transfers this data in one step? I just don't want to loop into thousands of records to insert them one by one into my MySQL database. It makes my program too slow and very unlikely to use... Thanks in advance Carlos Antonio -- 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]
Like MySQL Dump, but with FoxPro Tables
Hi all! I want to create an application that transfers data from FoxPro (*.dbf) tables to MySQL. Does MySQL have a DUMP like or LOAD LIKE function that transfers this data in one step? I just don't want to loop into thousands of records to insert them one by one into my MySQL database. It makes my program too slow and very unlikely to use... Thanks in advance Carlos Antonio -- 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]
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
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
mysql dump for remote db
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 - Original Message - From: "Victoria Reznichenko" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, January 28, 2003 2:27 AM Subject: re: question about primary key > On Monday 27 January 2003 10:27, Vicente Valero wrote: > > > I want to create a table with a numeric primary key as index in my sql. I > > want this > > index will be automatic. I've tried an auto_increment column, but if insert > > a non-correlative value then all new entries continue from this > > non-correlative value (1,2,3,4,1026,1027,...). It is possible use the first > > value not-used in the column automatically (1,2,3,1026,4,5,1000,6,7,...)? > > No, you can't do this automatically. > > > -- > 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 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
mysql dump not working
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. Any help is appreciated Mark - 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
mysql dump not working
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. Any help is appreciated Mark - 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: Using PHP to do a MySql Dump
AFAIK, there is no built-in function in PHP for a dump. That's at least what the manual says. An alternative is to use a system call e.g. system() or exec() with mysqldump. Hope that helps, Claudia >From Todd Cary <[EMAIL PROTECTED]> on Fri, Dec 20, 2002 at 08:35:02AM -0800 > Is there a function that can be implemented with PHP to do the > equivalent of a mysqldump? > > Todd > > -- Ariste Software, Petaluma, CA 94952 > > > - > 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: Using PHP to do a MySql Dump
Upon initial search, does not appear to be.
except: exec("mysqldump") or system(), or shell_exec()
Maybe the PHP list would render better results?
HTH
-Brad
Todd Cary wrote:
> Is there a function that can be implemented with PHP to do the
> equivalent of a mysqldump?
>
> Todd
>
> -- Ariste Software, Petaluma, CA 94952
>
> -
> 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: Using PHP to do a MySql Dump
You could do an SELECT * INTO OUTFILE (the documentation is on mysql's website). --Joe -- Joe Stump <[EMAIL PROTECTED]> http://www.joestump.net -Original Message- From: Todd Cary [mailto:[EMAIL PROTECTED]] Sent: Friday, December 20, 2002 8:35 AM To: [EMAIL PROTECTED] Subject: Using PHP to do a MySql Dump Is there a function that can be implemented with PHP to do the equivalent of a mysqldump? Todd -- Ariste Software, Petaluma, CA 94952 - 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
Using PHP to do a MySql Dump
Is there a function that can be implemented with PHP to do the equivalent of a mysqldump? Todd -- Ariste Software, Petaluma, CA 94952 - 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
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
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
