Re: mysql dump global read lock

[Lisa Smith]

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

[Artem Kuchin]

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

Recovery from a MySQL dump is too long !

[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. 

Do you have another ideas ? What's your advices ?

 Thanks in advance,

Re: Recovery from a MySQL dump is too long !

[Reindl Harald]

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

Re: Duplicate key name when importing mysql dump file

[Isart Montane]

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 jason.novo...@gmail.comwrote:

  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

[ars k]

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 isart.mont...@gmail.comwrote:

 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 jason.novo...@gmail.com
 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

[Jason Novotny]

  
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

If I use iconv to convert mysql dump data file with some blob field then blob binary data will be corrupted ?

[KLEIN Stéphane]

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: If I use iconv to convert mysql dump data file with some blob field then blob binary data will be corrupted ?

[KLEIN Stéphane]

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

Re: If I use iconv to convert mysql dump data file with some blob field then blob binary data will be corrupted ?

[KLEIN Stéphane]

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 ?

[KLEIN Stéphane]

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: mysql dump problems, no data dumped

[Andy Smith]

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

[Andy Smith]

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]

mysql dump problems, no data dumped

[Andy Smith]

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 problems, no data dumped

[Moon's Father]

Hi,andy.
   Can you show me the details about the options of mysqldump to be used ?

On Fri, Oct 31, 2008 at 1:25 AM, Andy Smith [EMAIL PROTECTED] wrote:

 Hi,

 Im having an issue using mysqldump to dump a DB from comercial app which
 includes mysql 4.0.18-pro. It doesnt however include mysql dump for online
 backups so Im using the one installed by default in my linux dist which as
 you can see below is version 10.11. My problem is that the dump is exiting
 with exist status 0 but Im not getting any of the data dumped. The WHOLE
 dump is shown in text below:

 -- MySQL dump 10.11
 --
 -- Host: localhostDatabase: OpManagerDB
 -- --
 -- Server version   4.0.18-pro
 /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
 /*!40103 SET TIME_ZONE='+00:00' */;
 /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
 /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS,
 FOREIGN_KEY_CHECKS=0
 */;
 /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
 /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
 /*!40103 SET [EMAIL PROTECTED] */;

 /*!40101 SET [EMAIL PROTECTED] */;
 /*!40014 SET [EMAIL PROTECTED] */;
 /*!40014 SET [EMAIL PROTECTED] */;
 /*!40111 SET [EMAIL PROTECTED] */;

 -- Dump completed on 2008-10-27 13:50:53

 Can anyone help me? I need to work out why no data is written,

 thanks Andy.




-- 
I'm a MySQL DBA in china.
More about me just visit here:
http://yueliangdao0608.cublog.cn

Re: mysql dump problems, no data dumped

[Jim Lyons]

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

mysql dump

[Naufal Sheikh]

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

[Michael Dykman]

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

[Naufal Sheikh]

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

[Michael Dykman]

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

[Naufal Sheikh]

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

[Craig Huffstetler]

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

[Naufal Sheikh]

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 help!

[Red Hope]

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
 
  shellmysqldump -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_mailp=summer+activities+for+kidscs=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!

[Red Hope]

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:\lillianmysqldump -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 
 
  shellmysqldump -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_mailp=summer+activities+for+kidscs=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_mailp=graduation+giftscs=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!

[Ananda Kumar]

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:\lillianmysqldump -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
 
  shellmysqldump -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_mailp=summer+activities+for+kidscs=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_mailp=graduation+giftscs=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!

[Gary Josack]

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:\lillianmysqldump -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 


shellmysqldump -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_mailp=summer+activities+for+kidscs=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_mailp=graduation+giftscs=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!

[Benjamin Wiechman]

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:\lillianmysqldump -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 

 shellmysqldump -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_mailp=summer+activities+for+kidsc
s=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_mailp=graduation+giftscs=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

Re: mysql dump help!

[Red Hope]

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:\lillianmysqldump -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 
 
  shellmysqldump -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:http://lists.mysql.com/[EMAIL PROTECTED]

Re: mysql dump help!

[Ofer Inbar]

 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]

mysql dump help!

[Red Hope]

Hey y'all,
I've been fussing with the MySQL dump procedure to
backup my stuff. I'm on MySQL 5.0.41 and I have tried
so hard to get it to dump my files into .sql format
but my syntax is wrong, wrong, wrong.  lol  

I put below examples what I've been entering to get my
databases backed up. I always get an error or I get
locked into the - thing if I don't use the
semicolons. 

Any help would be awesome!
Thank you,
Lillian

Tried  Wrong
mysqldump -u root -ppassword test  test.sql
mysqldump -u root -ppassword test  test.sql;
mysqldump -u root -ppassword -databases test 
test.sql;





   

Yahoo! oneSearch: Finally, mobile search 
that gives answers, not web links. 
http://mobile.yahoo.com/mobileweb/onesearch?refer=1ONXIC

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: mysql dump help!

[Carlos Proal]

One common error is trying to do this inside the mysql console, instead 
of the shell prompt, i think thats your problem because at least the 
first one is correct.


Carlos


Red Hope wrote:

Hey y'all,
I've been fussing with the MySQL dump procedure to
backup my stuff. I'm on MySQL 5.0.41 and I have tried
so hard to get it to dump my files into .sql format
but my syntax is wrong, wrong, wrong.  lol  


I put below examples what I've been entering to get my
databases backed up. I always get an error or I get
locked into the - thing if I don't use the
semicolons. 


Any help would be awesome!
Thank you,
Lillian

Tried  Wrong
mysqldump -u root -ppassword test  test.sql
mysqldump -u root -ppassword test  test.sql;
mysqldump -u root -ppassword -databases test 
test.sql;





   

Yahoo! oneSearch: Finally, mobile search 
that gives answers, not web links. 
http://mobile.yahoo.com/mobileweb/onesearch?refer=1ONXIC


  



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: mysql dump help!

[Red Hope]

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!

[Carlos Proal]

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!

[Red Hope]

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!

[Carlos Proal]

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!

[Mogens Melander]

mysqldump -u user -p -q --single-transaction --tab=/dest/dir database

or

mysql -u root -ppassword 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 \qenter 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!

[Mogens Melander]

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!

[Red Hope]

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 

shellmysqldump -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_mailp=summer+activities+for+kidscs=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!

[Ananda Kumar]

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

shellmysqldump -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_mailp=summer+activities+for+kidscs=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!

[Carlos Proal]

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:\lillianmysqldump -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 


shellmysqldump -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_mailp=summer+activities+for+kidscs=bz 

  



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

mysql dump restore.

[Ananda Kumar]

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

Restoring a database from a complete MySQL dump

[kent stand]

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 a database from a complete MySQL dump

[George Law]

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: mysql@lists.mysql.com
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]

Re: Restoring mySQL dump

[Adrian Cooper]

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

[Jay Blanchard]

[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

[Adrian Cooper]

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

[Jay Blanchard]

[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

[Adrian Cooper]

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

[Jay Blanchard]

[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]

Restoring mySQL dump

[Adrian Cooper]

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: Restoring mySQL dump

[Dwayne Hottinger]

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]

Re: Restoring mySQL dump

[Schalk Neethling]

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

[Karam Chand]

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]

MySQL dump (OT?)

[Erich Beyrent]

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 (OT?)

[Brent Baisley]

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 FILES

[Remember14a]

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 FILES

[Jeff Smelser]

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 Command Does Not Consider Foreign Key Dependencies

[Stephen Cuppett]

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:  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]

RE: MySQL Dump Command Does Not Consider Foreign Key Dependencies

[Carlos Proal]

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:  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

Re: MySQL Dump Command Does Not Consider Foreign Key Dependencies

[Heikki Tuuri]

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:  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

mysql dump file not completely importing

[Jeff Surcess]

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

[mysql] Dump table _files_ to a text file?

[Ryan Sinnwell]

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: [mysql] Dump table _files_ to a text file?

[robert_rowe]

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]

Like MySQL Dump, but with FoxPro Tables

[Carlos Vazquez]

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: Like MySQL Dump, but with FoxPro Tables

[Mojtaba Faridzad]

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]

Re: Like MySQL Dump, but with FoxPro Tables

[Ed Leafe]

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]

mysql dump speed

[dan orlic]

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  the mysql dump.dmp 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 speed

[Matt W]

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  the mysql dump.dmp it is taking
 about 28 hours to complete the load.

 Can anyone tell me what is taking so long?  Any thoughts as how to
speed
 it up?  Thanks in advance.

Was the dump done using the --opt option with mysqldump? This should
make reloading faster. What options *were* used? How is your application
doing INSERTs? LOCK TABLES and/or multi-line INSERT statements? Is it a
MyISAM table? If it's InnoDB, I think you'll need to do the INSERTs in
one transaction to get more speed. Maybe your app does this and
mysqldump isn't.

Just some thoughts. :-) Hope that helps.


Matt


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: mysql dump speed

[Brent Baisley]

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  the mysql dump.dmp 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

[Jon Frisby]

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  the mysql dump.dmp 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

[Jeremy Zawodny]

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 for remote db

[David T-G]

-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

[Mark Stringham]

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 mysql-unsubscribe-
[EMAIL PROTECTED]
 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

[Mark Stringham]

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 mysql-unsubscribe-
[EMAIL PROTECTED]
 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

[David T-G]

-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

  ?php
exec(du -h -d 1,$results,$exit) or die(Could not run du\n) ;
print space is:br\npre\n ;
print_r($results) ;
print /prebr\n ;
print exit code was '$exit'br\n ;
  ?

and see what you get.  If it works, whip up another about like

  ?php
$stamp = date(Y-m-d) ;
exec(mysqldump -uUSER -pPASS DATABASE,$results,$exit)
  or die(Could not run mysqldump\n) ;
print results are:br\npre\n . print_r($results)
  . /prebr\n ;
print exit code was '$exit'br\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

mysql dump for remote db

[Mark Stringham]

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 for remote db

[Nicholas Stuart]

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 user -ppass -h host database  file
to do your backup. Other then that I'm not sure how you could do this
since you already stated your service wont schedule cron jobs.

-Nick

Mark Stringham said:
 Does anyone have a suggestion as to how I could run a periodic mysql
 dump for a db that is hosted remotely - IE a web host. I do know that
 this host does not support crons.

 Any help is appreciated.

 thanks

 MS

 sql, query







-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: mysql dump for remote db

[Zak Greant]

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

[Dan Nelson]

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

mysql dump not working

[Mark Stringham]

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\binmysqldump -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

[Mark Stringham]

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\binmysqldump -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: mysql dump not working

[Mark Stringham]

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\binmysqldump  ?

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\binmysqldump -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

[Mark Stringham]

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\binmysqldump  ?

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\binmysqldump -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

[Zak Greant]

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\binmysqldump  ?

 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

[Zak Greant]

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\binmysqldump -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

[Paul DuBois]

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\binmysqldump  ?


 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

Using PHP to do a MySql Dump

[Todd Cary]

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: Using PHP to do a MySql Dump

[Joe Stump]

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

Re: Using PHP to do a MySql Dump

[Brad Bonkoski]

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

[Claudia Nölker]

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: Mysql dump error

[Dan Rossi]

ok i found the troubled table

DROP TABLE IF EXISTS `activity`;
CREATE TABLE `activity` (
  `int_activity_id` int(11) NOT NULL auto_increment,
  `vch_uniqid` varchar(50) NOT NULL default '',
  `int_user_id` int(11) NOT NULL default '0',
  `ts_time` int(50) NOT NULL default '0',
  `vch_page_viewed` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`int_activity_id`),
  UNIQUE KEY `int_activity_id` (`int_activity_id`),
  KEY `vch_uniqid` (`vch_uniqid`)
) TYPE=MyISAM;

wot could be the prob ?

-Original Message-
From: Dan Rossi [mailto:daniel;electroteque.org]
Sent: Thursday, November 07, 2002 6:11 PM
To: MySQL Mailing List
Subject: Mysql dump error


mysqldump: Got error: 1030: Got error 127 from table handler when retrieving
data
from server

for some reason i get this when i dump all databases

using mysqldump -p --all-databases --add-drop-table --quote-names 
all_databases.sql


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail
[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

re: Mysql dump error

[Egor Egorov]

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

Mysql dump error

[Dan Rossi]

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

[Georg Richter]

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 probable bug

[Michael Widenius]

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

[Victoria Reznichenko]

Stefano,
Friday, June 21, 2002, 4:43:29 PM, you wrote:

SI I found the following problem, which I consider a bug, but maybe I'm missing 
something to make it work correctly.

SI I'm using 'mysqldump' to backup our MySQL DB, and when I try to recover it on a 
blank DB it gives syntax errors while creating some table.
SI This is the Table structure which cause the error :

[skip]

SI When I try to run this command on the mysql console, I receive the following error 
:
SI mysql CREATE TABLE Test (
SI -   ID int(10) unsigned NOT NULL auto_increment,
SI -   IL varchar(12) NOT NULL default '',
SI -   Item_ID int(10) unsigned NOT NULL default '0',
SI -   BLDate datetime NOT NULL default '-00-00 00:00:00',
SI -   RelToTest datetime default NULL,
SI -   RelToRegr datetime default NULL,
SI -   RelToNPI datetime default NULL,
SI -   RelToCCO datetime default NULL,
SI -   SanityResult enum('None','Green','Red') NOT NULL default 'None',
SI -   PRIMARY KEY  (ID),
SI -   UNIQUE KEY Load (IL,Item_ID)
SI - ) TYPE=MyISAM COMMENT='SCM Internal Loads table';
SI ERROR 1064: You have an error in your SQL syntax near 'Load (IL,Item_ID)
SI ) TYPE=MyISAM COMMENT='SCM Internal Loads table'' at line 12

[skip]

SI Is really urgent for us to solve this problem, because our DB is growing fast and 
we would like to have a consistent Backup.
SI If I'm doing something wrong, please tell me.

LOAD is a reserved word:
 http://www.mysql.com/doc/R/e/Reserved_words.html

It's not recommended to use reserved words in table/column/key etc
names...
You can fix you problem just quoting LOAD with a ``' characters. Use
-Q or --quote-names option of mysqldump.

SI Best Regards,
SI Stefano




-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Victoria Reznichenko
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
   ___/   www.mysql.com




-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: MySQL dump/recovery probable bug

[Tod Harter]

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 - no bug at all

[Stefano Incontri]

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

[Roger Baklund]

* On-Site
 I'm very new to mySQL and have what is probably a simple question. I've
 created my database using mySQL and it resides on my local PC. I want to
 upload it to my hosting service's server.
 
 They tell me You would dump the content of your mysql database on your
 local machine and then use the mysql admin section we provide inside your
 member services section to import that content to your server database.
 
 I've looked for a dump type command and can't locate anything nor
 export/import. Can someone tell me how to go about getting my database
 loaded onto my hosting service's server. They support mySQL.

There is a utility called 'mysqldump' in your mysql\bin directory.

URL: http://www.mysql.com/doc/m/y/mysqldump.html 

-- 
Roger

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php