Re: Lost Connection Upon Loading Dump

On 4/21/2016 10:51, Stephen R Guglielmo wrote: Hello, I have a empty db that I'm trying to load a .sql file (created via mysqldump) into. The dump has 791611 lines and is 807 MB. Loading the dump is consistently failing at line 1763. Line 1763 is an INSERT statement. The line is

Lost Connection Upon Loading Dump

Hello, I have a empty db that I'm trying to load a .sql file (created via mysqldump) into. The dump has 791611 lines and is 807 MB. Loading the dump is consistently failing at line 1763. Line 1763 is an INSERT statement. The line is 95610 characters long. The error is: ERROR 2013 (HY000) at

Re: dump then truncate - in between anything?

s exactly what I'm trying you might want to look at the "rename" capability. Doing something like: rename -> rename -> will be much faster than trying to dump and empty a live table. With "rename" you'll have your data from the last period i

Re: dump then truncate - in between anything?

ht want to look at the "rename" capability. Doing something like: rename -> rename -> will be much faster than trying to dump and empty a live table. With "rename" you'll have your data from the last period in "" so can handle it at will. Y

dump then truncate - in between anything?

hi everybody I imagine this is theoretical rather than practical question, albeit I don't have much practice, so I hope experts could comment logical view of the procedure is: mysqldump && truncate - what are the chances that something gets in between and I loose it? many thanks L. -- MySQ

Re: dump, drop database then merge/aggregate

le and are hard to troubleshoot for people behind me that is expecting to have logic in code. Since you're having to script this behavior out anyway, if it were me I would dump the data in the table to CSV or similar using INSERT INTO OUTFILE rather than mysqldump, ship the file, and have a smal

Re: dump, drop database then merge/aggregate

Totally with you, I had to get up and wash my hands after writing such filth =) On Mon, Feb 29, 2016 at 12:14 PM, Gary Smith wrote: > On 29/02/2016 16:32, Steven Siebert wrote: > >> >> At risk of giving you too much rope to hang yourself: if you use >> mysqldump to dump

Re: dump, drop database then merge/aggregate

On 29/02/2016 16:32, Steven Siebert wrote: At risk of giving you too much rope to hang yourself: if you use mysqldump to dump the database, if you use the --replace flag you'll convert all INSERT statements to REPLACE, which when you merge will update or insert the record, effect

Re: dump, drop database then merge/aggregate

On 29/02/16 16:32, Steven Siebert wrote: What level of control do you have on the remote end that is collecting/dumping the data? Can you specify the command/arguments on how to dump? Is it possible to turn on binary logging and manually ship the logs rather than shipping the dump, effectively

Re: dump, drop database then merge/aggregate

What level of control do you have on the remote end that is collecting/dumping the data? Can you specify the command/arguments on how to dump? Is it possible to turn on binary logging and manually ship the logs rather than shipping the dump, effectively manually doing replication? I agree with

Re: dump, drop database then merge/aggregate

- Original Message - > From: "lejeczek" > Subject: Re: dump, drop database then merge/aggregate > > today both databases are mirrored/identical > tonight awkward end will dump then remove all the data, then > collect some and again, dump then remove > and

Re: dump, drop database then merge/aggregate

On 29/02/16 15:42, Gary Smith wrote: On 29/02/2016 15:30, lejeczek wrote: On 28/02/16 20:50, lejeczek wrote: fellow users, hopefully you experts too, could help... ...me to understand how, and what should be the best practice to dump database, then drop it and merge the dumps.. What I&#

Re: dump, drop database then merge/aggregate

On 29/02/2016 15:30, lejeczek wrote: On 28/02/16 20:50, lejeczek wrote: fellow users, hopefully you experts too, could help... ...me to understand how, and what should be the best practice to dump database, then drop it and merge the dumps.. What I'd like to do is something probably many

Re: dump, drop database then merge/aggregate

On 28/02/16 20:50, lejeczek wrote: fellow users, hopefully you experts too, could help... ...me to understand how, and what should be the best practice to dump database, then drop it and merge the dumps.. What I'd like to do is something probably many have done and I wonder how it's

dump, drop database then merge/aggregate

fellow users, hopefully you experts too, could help... ...me to understand how, and what should be the best practice to dump database, then drop it and merge the dumps.. What I'd like to do is something probably many have done and I wonder how it's done best. A box will be dumping

Re: mysql dump global read lock

Artem, You have --add-locks listed which will run LOCK TABLES prior to each table dump. --single-transaction is for InnoDB tables and ensures that they are copied in a consistent state. I hope this helps! On Thu, Dec 17, 2015 at 4:24 PM, Artem Kuchin wrote: > Hello! > > Hereis my

mysql dump global read lock

Hello! Hereis my mysqldump command line mysqldump -u root --events --complete-insert --skip-opt --single-transaction --add-drop-table --add-locks --create-options --disable-keys -- extended-insert --quick --set-charset --routines --triggers --hex-blob DB_NAME But i see tons of Waiting for

Re: Changing storage engine in dump file.

> > On Wed, Aug 12, 2015 at 9:21 AM, Johan De Meersman > wrote: > >> >> - Original Message - >> > From: "geetanjali mehra" >> > Subject: Changing storage engine in dump file. >> > >> > Is there any implications in doin

Re: Changing storage engine in dump file.

Depending on the version of MySQL and InnoDB engine, the max key length can be 3072 for InnoDB.. On Wed, Aug 12, 2015 at 9:21 AM, Johan De Meersman wrote: > > - Original Message - > > From: "geetanjali mehra" > > Subject: Changing storage engine in dum

Re: Changing storage engine in dump file.

is a mix >> of innodb and myisam tables. I want all my tables to be created in innodb >> on slave. >> >> I have planned to change the value of storage engine from innodb to myisam >> in dump file itself using sed . >> >> Running that dump file on the slave

Re: Changing storage engine in dump file.

it is better to take the dump as it is on the master, restore it on the salve and then change the storage engine through alter table commands that will be the right way of doing and you could see any issues while converting from MyISAM to InnoDB. On Wed, Aug 12, 2015 at 6:51 PM, Johan De Meersman

Re: Changing storage engine in dump file.

Am 12.08.2015 um 15:07 schrieb geetanjali mehra: I am in the process of creating a new slave. On my master, there is a mix of innodb and myisam tables. I want all my tables to be created in innodb on slave. I have planned to change the value of storage engine from innodb to myisam in dump file

Re: Changing storage engine in dump file.

- Original Message - > From: "geetanjali mehra" > Subject: Changing storage engine in dump file. > > Is there any implications in doing so. Is this approach correct? Will I > face any problem in syncing the slave? The first thing that occurs to me, is that t

Changing storage engine in dump file.

Hi, I am in the process of creating a new slave. On my master, there is a mix of innodb and myisam tables. I want all my tables to be created in innodb on slave. I have planned to change the value of storage engine from innodb to myisam in dump file itself using sed . Running that dump file on

RE: Core Dump

bugs.mysql.com > -Original Message- > From: Ben Clewett [mailto:b...@clewett.org.uk] > Sent: Thursday, September 05, 2013 6:38 AM > To: mysql@lists.mysql.com > Subject: Core Dump > > Dear MySQL, > > Using 5.1.56, I have experienced this core dump. I

Core Dump

Dear MySQL, Using 5.1.56, I have experienced this core dump. Is there anybody out there qualified to give an opinion on this? Many thanks, Ben Clewett. Thread pointer: 0x7fd5280dbd90 Attempting backtrace. You can use the following information to find out where mysqld died. If you see no

RE: Mysqldump routines dump, problem with lock tables.

Do not try to dump or reload information_schema. It is derived meta information, not real tables. > -Original Message- > From: Rafał Radecki [mailto:radecki.ra...@gmail.com] > Sent: Monday, February 04, 2013 12:17 AM > To: mysql@lists.mysql.com > Subject: Mysqldum

Mysqldump routines dump, problem with lock tables.

Hi All. I use: # rpm -qa | grep -i percona-server-server Percona-Server-server-55-5.5.28-rel29.3.388.rhel6.x86_64 My system: # uname -a;cat /etc/redhat-release Linux prbc01.mg.local 2.6.32-279.19.1.el6.centos.plus.x86_64 #1 SMP Wed Dec 19 06:20:23 UTC 2012 x86_64 x86_64 x86_64 GNU/Linux Red Hat

Re: get a partial dump

W dniu 2012-10-18 16:27, Stefan Kuhn pisze: Hi everybody, I want to get insert statements from a mysql database for a number of rows of a table, specified by a where clause. I also need the inserts for the datasets linked via foreign keys in other tables. So I need a sort of partial dump, a bit

Re: get a partial dump

via foreign keys in other tables. So I need a sort of > > partial > > dump, a bit like mysqldump, but restricted to a (small) set of data. This > > needs to be done in a Java program, using mysql via jdbc. > > Does anybody know an easy way to do this? Of course I could build t

Re: get a partial dump

erts for the > datasets linked via foreign keys in other tables. So I need a sort of > partial > dump, a bit like mysqldump, but restricted to a (small) set of data. This > needs to be done in a Java program, using mysql via jdbc. > Does anybody know an easy way to do this?

get a partial dump

Hi everybody, I want to get insert statements from a mysql database for a number of rows of a table, specified by a where clause. I also need the inserts for the datasets linked via foreign keys in other tables. So I need a sort of partial dump, a bit like mysqldump, but restricted to a (small

Re: Recovery from a MySQL dump is too long !

Am 14.08.2012 09:42, schrieb Bob Sauvage: > Hello *, > > My INNODB database has a size of 80GO. I've a replication setup on 3 slaves > and I backup my db from them. > If a problem occurs on the database, a recovery from a dump takes around 6H ! > That's too long

Recovery from a MySQL dump is too long !

Hello *, My INNODB database has a size of 80GO. I've a replication setup on 3 slaves and I backup my db from them. If a problem occurs on the database, a recovery from a dump takes around 6H ! That's too long for us. 2 ideas : 1. Stop the slave and rsync the folder /var/li

Re: Reading Schema From a MSSQL Dump on a Mac (or Linux)

- Original Message - > From: "Stan Iverson" > Yes, it's a binary file; however, MySQL Connector for ODBC only works > in Windows and I'm using a Mac. If no other solutions, will try > tomorrow on a friend's PC. If it's binary, you're gonna have no other choice but to restore the files o

Re: Reading Schema From a MSSQL Dump on a Mac (or Linux)

Hello Stan, On 2/3/2012 20:06, Stan Iverson wrote: On Fri, Feb 3, 2012 at 11:11 AM, Johan De Meersmanwrote: - Original Message - From: "Stan Iverson" I have a Mac and a Linux server and I need to read the table schema for a database dump from MSSQL. Possible? How? Heeh.

Re: Reading Schema From a MSSQL Dump on a Mac (or Linux)

On Fri, Feb 3, 2012 at 11:11 AM, Johan De Meersman wrote: > - Original Message - > > From: "Stan Iverson" > > > > I have a Mac and a Linux server and I need to read the table schema > > for a database dump from MSSQL. Possible? How? > > Heeh.

Re: Reading Schema From a MSSQL Dump on a Mac (or Linux)

- Original Message - > From: "Stan Iverson" > > I have a Mac and a Linux server and I need to read the table schema > for a database dump from MSSQL. Possible? How? Heeh. If you're talking about an SQL dump into a textfile, that should be doable - you m

Re: Reading Schema From a MSSQL Dump on a Mac (or Linux)

If you only need to view the schema, and not load the data, you could open the dump file using a text editor like BBedit or TextWrangler (you would have to Google the websites as I am away from my desk right now). Wendell Turner +44(0) 777 164 6532 wendel...@gmail.com

Re: Reading Schema From a MSSQL Dump on a Mac (or Linux)

On Fri, Feb 3, 2012 at 10:01 AM, Wendell Turner wrote: > Hi. > > On a Mac, you could use... > * SequelPro > It appears one has to have a database up and running to open the backup. I can get MySQL running, but, again, the backup is of a MSSQL database. I don't have MS

Re: Reading Schema From a MSSQL Dump on a Mac (or Linux)

ere is a profound difference between doing things right and doing the right things." On 3 Feb 2012, at 13:52, Stan Iverson wrote: > Hi; > I have a Mac and a Linux server and I need to read the table schema for a > database dump from MSSQ

Re: How to dump MySQL data on remote server using mysqldump

On 02/09/2010 7:19 a, James Corteciano wrote: How could I put the dump data on web server and not the local disk on mysql server? Log into the web server and do it from there? or copy the file onto the web server? -- Jangita | +256 76 91 8383 | Y! & MSN: jang...@yahoo.com Skype: jan

Re: How to dump MySQL data on remote server using mysqldump

>From the mysqldump manpage, on the -T option: Note > This option should be used only when mysqldump is run on the same machine > as the mysqld server. You must have the FILE privilege, and the server must > have permission to write files in the directory that you specify. > In other words, you'v

RE: How to dump MySQL data on remote server using mysqldump

Worx redwa...@logicworks.net http://www.linkedin.com/in/rolandoedwards -Original Message- From: James Corteciano [mailto:ja...@linux-source.org] Sent: Thursday, September 02, 2010 1:19 AM To: mysql@lists.mysql.com Subject: How to dump MySQL data on remote server using mysqldump Hi, I have m

How to dump MySQL data on remote server using mysqldump

Hi, I have mysql server separated from web server. My problem is, when I dump the data from database using the command "mysqldump -uuser -p -h mysql_server -t -T /tmp/dbname database_name" on web server, all data were dumped to the /tmp/dbname of mysql server and not inside of web ser

Peer review maatkits mk-parallel-dump and mk-parallel-restore usage

Hiya Im trying to make use of maatkit as a means of dumping a database and then restoring to another database. For dumps: mk-parallel-dump --user abc --password xyz --databases currentdb --base-dir /tmp/dump For restore: mk-parallel-restore --create-databases --user abc --password xyz

Re: Loading 4.1.12 dump to 5.0.18 server

On Thu, Apr 22, 2010 at 9:39 PM, Rob Wultsch wrote: > On Thu, Apr 22, 2010 at 1:42 PM, Larry Martell > wrote: >> I need to load a dump from a 4.1.12 server to a 5.0.18 server. When I >> do that it fails with: >> > Upgrading from an early 4.1 series to an incredibly

Re: Loading 4.1.12 dump to 5.0.18 server

On Thu, Apr 22, 2010 at 8:19 PM, Shawn Green wrote: > Larry Martell wrote: >> >> I need to load a dump from a 4.1.12 server to a 5.0.18 server. When I >> do that it fails with: >> >> ERROR 1064 (42000) at line 23: You have an error in your SQL syntax; >> ch

Re: Loading 4.1.12 dump to 5.0.18 server

On Thu, Apr 22, 2010 at 1:42 PM, Larry Martell wrote: > I need to load a dump from a 4.1.12 server to a 5.0.18 server. When I > do that it fails with: > Upgrading from an early 4.1 series to an incredibly early 5.0 series is a bad idea. Your first priority should be upgrading your de

Re: Loading 4.1.12 dump to 5.0.18 server

Larry Martell wrote: I need to load a dump from a 4.1.12 server to a 5.0.18 server. When I do that it fails with: ERROR 1064 (42000) at line 23: 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 'BTREE (`b

Loading 4.1.12 dump to 5.0.18 server

I need to load a dump from a 4.1.12 server to a 5.0.18 server. When I do that it fails with: ERROR 1064 (42000) at line 23: 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 'BTREE (`bookId`,`productId`,`clus

Factors for slower mysqldump on superior hardware vrs faster dump on slower hardware. Same install. Why?

Hello, Iam using OpenBSD 4.6 GENERIC kernel with mysql-server . Machine A (faster) AMD Athlon(tm) 64 X2 Dual Core Processor 5200+ ("AuthenticAMD" 686-class, 512KB L2 cache) 2.72 GHz 2GB of RAM wd0 at pciide1 channel 0 drive 0: wd0: 16-sector PIO, LBA48, 152627MB, 312581808 sectors wd0(pciide1:

Re: dump time progressively increasing with Innodb

OPTIMIZE TABLE sometimes helps, ymmv. http://dev.mysql.com/doc/refman/5.1/en/optimize-table.html / Carsten Nico Sabbi skrev: Hi, I noticed that over the months the dump of my databases (very subject to modifications, but not subject to increase significantly in size) gets progressively

dump time progressively increasing with Innodb

Hi, I noticed that over the months the dump of my databases (very subject to modifications, but not subject to increase significantly in size) gets progressively slower: from ~8 minutes to almost 15 in 6 months. How can I avoid this degeneration? Thanks, Nico -- MySQL General

Re: can't dump a database with views: "stack smashing detected ***: mysqldump terminated"

On 22.02.2010 13:04, Jesper Wisborg Krogh wrote: On 22/02/2010, at 9:20 PM, Tomasz Chmielewski wrote: When I try to dump a database which contains views, mysqldump crashes: # mysqldump -u root --opt --password=secret database > dump.sql *** stack smashing detected ***: mysqldump termina

Re: can't dump a database with views: "stack smashing detected ***: mysqldump terminated"

On 22/02/2010, at 9:20 PM, Tomasz Chmielewski wrote: When I try to dump a database which contains views, mysqldump crashes: # mysqldump -u root --opt --password=secret database > dump.sql *** stack smashing detected ***: mysqldump terminated Aborted # I use MySQL 5.0.89-0.glibc23 binar

can't dump a database with views: "stack smashing detected ***: mysqldump terminated"

When I try to dump a database which contains views, mysqldump crashes: # mysqldump -u root --opt --password=secret database > dump.sql *** stack smashing detected ***: mysqldump terminated Aborted # I use MySQL 5.0.89-0.glibc23 binaries from MySQL website. Is it a known problem? Are there

RE: how to dump database or tables

>-Original Message- >From: Anand kumar [mailto:anand@gmail.com] >Sent: Friday, January 29, 2010 4:36 AM >To: Suresh Kuna >Cc: muralikrishna g; mysql@lists.mysql.com >Subject: Re: how to dump database or tables > >it should be windows.. . > [JS] This will get

Re: how to dump database or tables

harset ) and -e ( use multiple-row INSERT syntax that include several VALUES lists. This results in a smaller dump file and speeds up inserts when the file is reloaded ). Consider to use -e option when you have a big backup - *you will get more faster restore*, improving the time-recovery. *Make a

Re: how to dump database or tables

gt; > i have created several data bases and tables in that.. to take backup, we > > have to use dump., i dont know the correct syntax how to use dump to take > > backup to a specific location., after that how to resore. please help me > > regarding this. > > thanks in advance > > >

Re: how to dump database or tables

Which OS your are using ? Suresh Kuna MySQL DBA On Fri, Jan 29, 2010 at 2:25 PM, muralikrishna g wrote: > i am working on my pc with mysql-5.0.27-community-nt > > i have created several data bases and tables in that.. to take backup, we > have to use dump., i dont know the correct s

how to dump database or tables

i am working on my pc with mysql-5.0.27-community-nt i have created several data bases and tables in that.. to take backup, we have to use dump., i dont know the correct syntax how to use dump to take backup to a specific location., after that how to resore. please help me regarding this. thanks

Re: mysqldump vs phpmyadmin dump

t; >> The problem what I found is that mysqldump and phpmyadmin generate >> different >> size of backup file against same database. >> >> I try to dump same database with the 2 different methods, the original >> database is 2.8mb, phpmyadmin export 1.5mb file, and

Re: mysqldump vs phpmyadmin dump

Wang Zi Feng wrote: Hi everyone, Here is a rookie question. The problem what I found is that mysqldump and phpmyadmin generate different size of backup file against same database. I try to dump same database with the 2 different methods, the original database is 2.8mb, phpmyadmin export 1.5mb

mysqldump vs phpmyadmin dump

Hi everyone, Here is a rookie question. The problem what I found is that mysqldump and phpmyadmin generate different size of backup file against same database. I try to dump same database with the 2 different methods, the original database is 2.8mb, phpmyadmin export 1.5mb file, and mysqldump

RE: Dump / restore rows in table?

>-Original Message- >From: Jerry Schwartz [mailto:jschwa...@the-infoshop.com] >Sent: Wednesday, October 07, 2009 2:15 PM >To: 'John Oliver'; mysql@lists.mysql.com >Subject: RE: Dump / restore rows in table? > [JS] I should have mentioned that you can do thi

RE: Dump / restore rows in table?

032 860.674.8796 / FAX: 860.674.8341 www.the-infoshop.com >-Original Message- >From: John Oliver [mailto:joli...@john-oliver.net] >Sent: Wednesday, October 07, 2009 12:29 PM >To: mysql@lists.mysql.com >Subject: Dump / restore rows in table? > >I did try to find out how

Re: Dump / restore rows in table?

In the last episode (Oct 07), John Oliver said: > I did try to find out how to do this in the manual, but "row" and > "table" occur so many times... > > I want to dump a certain number of rows from one table, and then restore > them to another database. I&#x

Dump / restore rows in table?

I did try to find out how to do this in the manual, but "row" and "table" occur so many times... I want to dump a certain number of rows from one table, and then restore them to another database. I'm guessing I'd try "mysqldump -u root -pPASSWORD database_name

Re: Duplicate key name when importing mysql dump file

Hi Jason, You may have to run "ANALYZE TABLE.." for the particular table for which you are facing the error. So it'll rebuild the indexes. This would be the best one to save your data. We can use the method which Mr.Isart suggested, but it'll ignore the error and also will lead to data loss. Rega

Re: Duplicate key name when importing mysql dump file

Hi Jason, if you run mysql with -f it will ignore any errors and continue importing cat aac.sql | mysql -f -u root AAC Isart On Wed, Jun 17, 2009 at 8:59 PM, Jason Novotny wrote: > Hi, > > I'm trying to import a dumpfile like so: > > cat aac.sql | mysql -u root AAC > > It all runs fine unti

Duplicate key name when importing mysql dump file

Hi, I'm trying to import a dumpfile like so: cat aac.sql | mysql -u root AAC It all runs fine until I get something like: ERROR 1061 (42000) at line 5671: Duplicate key name 'FK_mediaZip_to_zipSet' Is there a way I can tell it to ignore or replace the key? Thanks, Jason -- MySQL Gene

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

gt;> >> * 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 --

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

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=ro

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

I've break line misteak in my previous message, this is the fix : $ mysqldump --user=root --password=password --host=mybox mydatabase -- default-character-set=latin1 > mydatabase.latin1.sql$ mysqldump -- user=root --password=password --host=mybox mydatabase --default-character- set=latin1 > mydata

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

Hi, This my script to convert latin1 database to utf8 : $ mysqldump --user=root --password=password --host=mybox mydatabase -- default-character-set=latin1 > mydatabase.latin1.sql$ mysqldump -- user=root --password=password --host=mybox mydatabase --default-character- set=latin1 > mydatabase.lati

RE: mysql dump problems, no data dumped

This is a known bug, Ive installed MySQL 4 client binaries as a work around... _ From: Andy Smith [mailto:[EMAIL PROTECTED] Sent: 2008-10-30 18:26 To: 'mysql@lists.mysql.com' Subject: mysql dump problems, no data dumped Im having an issue using mysqldump to dump a DB from

RE: mysql dump problems, no data dumped

ng 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=

Re: mysql dump problems, no data dumped

what command are you using to do the dump? I mean the entire command, including all the options. On Thu, Oct 30, 2008 at 12:25 PM, Andy Smith <[EMAIL PROTECTED]> wrote: > Hi, > > Im having an issue using mysqldump to dump a DB from comercial app which > includes mysql 4.0

Re: mysql dump problems, no data dumped

Hi,andy. Can you show me the details about the options of mysqldump to be used ? On Fri, Oct 31, 2008 at 1:25 AM, Andy Smith <[EMAIL PROTECTED]> wrote: > Hi, > > Im having an issue using mysqldump to dump a DB from comercial app which > includes mysql 4.0.18-pro. It does

mysql dump problems, no data dumped

Hi, Im having an issue using mysqldump to dump a DB from comercial app which includes mysql 4.0.18-pro. It doesnt however include mysql dump for online backups so Im using the one installed by default in my linux dist which as you can see below is version 10.11. My problem is that the dump is

Can I dump procedures with mysqldump using --tabs?

I usually use the --tabs option on mysqldump. However, if a table has a function, procedure, or trigger, the code is not written to a file but rather to standard out. Is this the only way to dump them using the --tabs option? I thought of trying to use the Information Schema database somehow

Re: Dump problem

m ready to move away from that provider, so I want to take a dump of the data. I've tried many mysqldump options, but I always get a file full of giberish. Using iconv on the file doesn't even work... So my question is: How do you take a dump of a swedish-based database, and end up with

Dump problem

website's output is Arabic windows-1256. Now I am ready to move away from that provider, so I want to take a dump of the data. I've tried many mysqldump options, but I always get a file full of giberish. Using iconv on the file doesn't even work... So my question is: How do you

Re: How to import oracle dump?

tools/migration-toolkit/ > > Raj Mehrotra > HCCS - Experts in Healthcare Learning > > > > > > > -Original Message- > From: Metalpalo [mailto:[EMAIL PROTECTED] > Sent: Tuesday, March 18, 2008 3:25 AM > To: mysql@lists.mysql.com > Subject: How to import or

RE: How to import oracle dump?

Subject: How to import oracle dump? Hello I have got one question. I need to convert oracle dump file and import it to MySQl server. I have found some utitlity OraDump-to-MySQL but it is not free and convert only 5 record from each table. Can somebody help me ? Thanks -- View this message in

How to import oracle dump?

Hello I have got one question. I need to convert oracle dump file and import it to MySQl server. I have found some utitlity OraDump-to-MySQL but it is not free and convert only 5 record from each table. Can somebody help me ? Thanks -- View this message in context: http://www.nabble.com/How

Re: mysql dump

; 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. &#

mysql dump

Hello every one, I have two questions actually. If there is a database server with couple of databases, and we only want to take the dump of few of them, can we specify a list of those on either mysqldump or mysql prompt ( for any other purpose ).or we have to run the mysqldump command seperately

Re: mysql dump

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

Re: mysql dump

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

Re: mysql dump

So is it safe to take the dump while database is running. I mean is there any loss of data expected because of taking dump while a database is running. On Nov 13, 2007 2:26 PM, Michael Dykman <[EMAIL PROTECTED]> wrote: > > On Nov 13, 2007 2:11 PM, Naufal Sheikh <[EMAIL PR

Re: mysql dump

; 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 spec

mysql dump

Hello everyone, Few conceptual questions which I can't understand. If any one can please gimme a a quicky! Am I correct when I say that "mysqldump' only works when the database is up and running? and if it is true can any one please tell me that does taking a dump when a databas

Re: mysql dump help!

> On 7/24/07, Red Hope <[EMAIL PROTECTED]> wrote: > >mysql> > > > >mysql> \R shell> > >PROMPT set to 'shell>' > > > >shell> It doesn't matter what the prompt says, it's still mysql you're running here. When people say "the shell prompt" they don't mean "make your prompt say the word shell", they

Re: mysql dump help!

; server version for the right syntax to use near > >>> 'mysqldump -u root -ppassword test > test.sql' > at > >>> > >> line > >> > >>> 1 > >>> > >>> > >>> > >>> --- Carlos

RE: mysql dump help!

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

Re: mysql dump help!

itch 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

Re: mysql dump help!

gt; > > > > >> Can you email us the complete command and the > error > >> ? > >> > >> Carlos > >> > >> > >> Red Hope wrote: > >> > >>> Well, that went over my head. :) I understand > >>> > >>

Re: mysql dump help!

gt;> Carlos > >> > >> > >> Red Hope wrote: > >> > >>> Well, that went over my head. :) I understand > >>> > >> what > >> > >>> you're telling me, how to get there, but not how >

  1   2   3   4   5   6   >