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

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

Recovery from a MySQL dump is too long !

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

Re: Recovery from a MySQL dump is too long !

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

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 jason.novo...@gmail.comwrote: Hi, I'm trying to import a dumpfile like so: cat aac.sql | mysql -u root AAC It

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.

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

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

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

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

Le Tue, 23 Dec 2008 14:42:40 +, KLEIN Stéphane a écrit : Hi, This my script to convert latin1 database to utf8 : $ mysqldump --user=root --password=password --host=mybox mydatabase -- default-character-set=latin1 mydatabase.latin1.sql$ mysqldump -- user=root --password=password

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

Le Tue, 23 Dec 2008 15:33:34 +, KLEIN Stéphane a écrit : Le Tue, 23 Dec 2008 14:42:40 +, KLEIN Stéphane a écrit : Hi, This my script to convert latin1 database to utf8 : $ mysqldump --user=root --password=password --host=mybox mydatabase -- default-character-set=latin1

RE: mysql dump problems, no data dumped

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

RE: mysql dump problems, no data dumped

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

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

Re: mysql dump problems, no data dumped

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

Re: mysql dump problems, no data dumped

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

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

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.

mysql dump

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

Re: mysql dump

On Nov 13, 2007 2:11 PM, Naufal Sheikh [EMAIL PROTECTED] wrote: Hello everyone, Few conceptual questions which I can't understand. If any one can please gimme a a quicky! Am I correct when I say that mysqldump' only works when the database is up and running? and if it is true can any one

Re: mysql dump

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

Re: mysql dump

No, but a table lock or two may be expected. This is to PREVENT data loss (which you were also worried about). The mysqldump process will most likely be quick and painless (quick being a relative term, depending on the amount of data in your database(s)). Craig On Nov 13, 2007 2:35 PM, Naufal

Re: mysql dump

Thank you so much! On Nov 13, 2007 2:40 PM, Craig Huffstetler [EMAIL PROTECTED] wrote: No, but a table lock or two may be expected. This is to PREVENT data loss (which you were also worried about). The mysqldump process will most likely be quick and painless (quick being a relative term,

Re: mysql dump help!

I cut and pasted what you typed and just altered the password. It didn't like it all. Same error again. If I put any command in without the ; at the end then I'll get locked into this - thingy unless I clear out. I can't guess why it won't take it. Lillian --- Ananda Kumar [EMAIL PROTECTED]

Re: mysql dump help!

I'm curious about one thing. When I go into MySQL folder on the hard drive. I go into the 'bin' folder, should there be an .exe program called mysqldump? or not? Lillian --- Carlos Proal [EMAIL PROTECTED] wrote: Yep, good for you, welcome to the real world You are changing the prompt but

Re: mysql dump help!

did u try this mysqldump -u root -ppassword --database test test.sql On 7/24/07, Red Hope [EMAIL PROTECTED] wrote: I'm curious about one thing. When I go into MySQL folder on the hard drive. I go into the 'bin' folder, should there be an .exe program called mysqldump? or not? Lillian

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

RE: mysql dump help!

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

Re: mysql dump help!

I did have some luck, y'all after several hours. Originally there wasn't a mysqldump.exe in the bin folder so I redid everything. I went through regular ole ms-dos and was able to run it through fine. I just needed it to get converted to a .sql file so I can upload it to my web server. I

Re: mysql dump help!

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

mysql dump help!

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

Re: mysql dump help!

One common error is trying to do this inside the mysql console, instead of the shell prompt, i think thats your problem because at least the first one is correct. Carlos Red Hope wrote: Hey y'all, I've been fussing with the MySQL dump procedure to backup my stuff. I'm on MySQL 5.0.41

Re: mysql dump help!

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

Re: mysql dump help!

: One common error is trying to do this inside the mysql console, instead of the shell prompt, i think thats your problem because at least the first one is correct. Carlos Red Hope wrote: Hey y'all, I've been fussing with the MySQL dump procedure to backup my stuff. I'm on MySQL 5.0.41

Re: mysql dump help!

, 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

Re: mysql dump help!

Can you email us the complete command and the error ? Carlos Red Hope wrote: Well, that went over my head. :) I understand what you're telling me, how to get there, but not how to do it. bleh. When I start up MySQL Command Line Client, I'm always prompted at mysql. So I told it to

Re: mysql dump help!

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

Re: mysql dump help!

I think we are daling with a windows user, who are not that familiar with a command prompt. Correct me if i'm wrong. How to get to a point where you would be able to execute a mysqldump, will depend on what OS you are running, and how you installed MySQL. On Tue, July 24, 2007 04:41, Carlos

Re: mysql dump help!

Hey y'all, I use charming Windows XP on here. I've taken database classes but lucky for me we never used *real* MySQL. Below I typed up exactly what I put into the MySQL prompt and this is what it kicks back to me. Lillian mysql mysql \R shell PROMPT set to 'shell' shell shellmysqldump -u

Re: mysql dump help!

try this mysqldump -u root -ppassword --database test test.sql On 7/24/07, Red Hope [EMAIL PROTECTED] wrote: Hey y'all, I use charming Windows XP on here. I've taken database classes but lucky for me we never used *real* MySQL. Below I typed up exactly what I put into the MySQL prompt and

Re: mysql dump help!

Yep, good for you, welcome to the real world You are changing the prompt but are still inside the dbms, you need to get out, because mysqldump is an application (.exe file) not a sql command, ie Welcome to the MySQL monitor.

mysql dump restore.

Hi All, I have a mysqldump take from machine A on 14th July,2007. When i took the mysqldump the bin-log file name postion was Master_Log_File: mysql-bin.34 Read_Master_Log_Pos: 155537266. Now i have restored this dump into another machine B which already had log_bin enabled. Its current

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

Re: Restoring a database from a complete MySQL dump

] 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

Re: Restoring mySQL dump

. 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

RE: Restoring mySQL dump

[snip] mysql -u root -p dbname backupname.sql And getting: ERROR 1064 at line 20: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'DEFAULT CHARSET=latin1' at line 7 [/snip] Can we see the first 10 lines of

Re: Restoring mySQL dump

Hello, Yes, here are the first 10 lines: -- MySQL dump 10.9 -- -- Host: localhostDatabase: account_databasename -- -- -- Server version 4.1.8-standard /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET

RE: Restoring mySQL dump

[snip] Yes, here are the first 10 lines: -- MySQL dump 10.9 -- -- Host: localhostDatabase: account_databasename -- -- -- Server version 4.1.8-standard /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET

Re: Restoring mySQL dump

Hello, None of these lines describe the problem that you are having with syntax. Can you give us 5 lines either side of the line that includes 'DEFAULT CHARSET=latin1'? Yes, here it is: `user_id` mediumint(8) unsigned NOT NULL default '0', `group_id` mediumint(8) unsigned NOT NULL default '0',

RE: Restoring mySQL dump

[snip] `user_id` mediumint(8) unsigned NOT NULL default '0', `group_id` mediumint(8) unsigned NOT NULL default '0', `quota_type` smallint(2) NOT NULL default '0', `quota_limit_id` mediumint(8) unsigned NOT NULL default '0', KEY `quota_type` (`quota_type`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1;

Restoring mySQL dump

Hello, I need to restore a mySQL dump file but cannot find the right syntax. I have root access and have used: mysql -u root -p account_databasename backupname But I am getting: Access denied for user '[EMAIL PROTECTED]' (Using password: YES) I have also removed the root password and got

Re: Restoring mySQL dump

That is correct. The password for mysql root is probably not the same as the system root. ddh Quoting Adrian Cooper [EMAIL PROTECTED]: Hello, I need to restore a mySQL dump file but cannot find the right syntax. I have root access and have used: mysql -u root -p account_databasename

Re: Restoring mySQL dump

Can you sign -in as root user i.e. Administrator? Using: mysql -u username -p password? Dwayne Hottinger wrote: That is correct. The password for mysql root is probably not the same as the system root. ddh Quoting Adrian Cooper [EMAIL PROTECTED]: Hello, I need to restore a mySQL dump file

Re: Restoring mySQL dump

Since I am on Windows, I prefer to use a GUI tool like SQLyog (www.webyog.com) Karam --- Adrian Cooper [EMAIL PROTECTED] wrote: Hello, I need to restore a mySQL dump file but cannot find the right syntax. I have root access and have used: mysql -u root -p account_databasename

MySQL dump (OT?)

Hi all, This is perhaps off-topic, but I need to dump my MySQL database into a format that FileMaker Pro will understand. Does anyone have any tips for doing this? Thanks in advance, Erich -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

Re: MySQL dump (OT?)

You could try setting up FileMaker to query MySQL directly, using ODBC. Otherwise, you can't create a FileMaker database directly, so you need to create an import format that FileMaker understands (tab, command, sylk, etc.). You would need to keep in mind that you may have embedded returns

MYSQL DUMP FILES

Dear friends, I am using following command to dump mysql database files, mysql mysqldump b - c:/hdump/dump.sql where c:/hdump/dump.sql is the path where database files should be stored, however its not working. Any guidance, please.

Re: MYSQL DUMP FILES

On Saturday 14 August 2004 01:06 am, [EMAIL PROTECTED] wrote: mysql mysqldump b - c:/hdump/dump.sql Do it from the command line, not mysql command prompt. -- === Jabber: tradergt@(smelser.org|jabber.org) Quote: We don't

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

RE: MySQL Dump Command Does Not Consider Foreign Key Dependencies

}/${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

Re: MySQL Dump Command Does Not Consider Foreign Key Dependencies

- 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

mysql dump file not completely importing

Hi, As my database has grown I have found that the dump isn't completely restoring to my development machine (XP Pro). The file is now up to about 30 MB but it only imports about half the tables. The command I'm using to restore the db is: d:\mysql\bin\mysql.exe -h localhost -u username

[mysql] Dump table _files_ to a text file?

I have a MySQL installation that went terribly wrong so I changed to a different server, reset everything up and am up and running again. The problem is, I'm so new to this I didn't know how to move my databases, and since there wasn't much information in them (about two weeks worth of posts

Re: [mysql] Dump table _files_ to a text file?

Just copy the database folder to your new server. If they are not corrupt then they should be accessible from your new server. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

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

Re: Like MySQL Dump, but with FoxPro Tables

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

Re: Like MySQL Dump, but with FoxPro Tables

On Monday, September 29, 2003, at 03:29 PM, Carlos Vazquez wrote: I want to create an application that transfers data from FoxPro (*.dbf) tables to MySQL. Does MySQL have a DUMP like or LOAD LIKE function that transfers this data in one step? I just don't want to loop into thousands of

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

Re: mysql dump speed

Hi Dan, - Original Message - From: dan orlic [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, September 11, 2003 2:30 PM Subject: mysql dump speed I have a bit of an issue with mysqldumps and inserting it back into mysql. Granted, I have 1 table that has over 1Million entries

Re: mysql dump speed

Have tried using the --opt parameter on mysqldump? This is supposed optimize the dump speed and create a file optimized for reloading. I haven't played with this option, so I don't know what kind of difference it makes. On Thursday, September 11, 2003, at 03:30 PM, dan orlic wrote: I have a

RE: mysql dump speed

Use the --opt option when performing the dump. It can make a tremendous difference. -JF -Original Message- From: dan orlic [mailto:[EMAIL PROTECTED] Sent: Thursday, September 11, 2003 12:31 PM To: [EMAIL PROTECTED] Subject: mysql dump speed I have a bit of an issue

Re: mysql dump speed

On Thu, Sep 11, 2003 at 04:27:10PM -0400, Brent Baisley wrote: Have tried using the --opt parameter on mysqldump? This is supposed optimize the dump speed and create a file optimized for reloading. I haven't played with this option, so I don't know what kind of difference it makes. It

Re: mysql dump for remote db

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Mark -- ...and then Mark Stringham said... % % Does anyone have a suggestion as to how I could run a periodic mysql dump % for a db that is hosted remotely - IE a web host. I do know that this host % does not support crons. Do you want it dumped

Re: mysql dump for remote db

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

Re: mysql dump for remote db

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

Re: mysql dump for remote db

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Mark -- ...and then Mark Stringham said... % % Well it looks like I have limited options. Yep. Hey, you could always host with me ;-) % % I'm guessing that the web host will let me have limited rights to the % server as it is - probably only

mysql dump for remote db

Does anyone have a suggestion as to how I could run a periodic mysql dump for a db that is hosted remotely - IE a web host. I do know that this host does not support crons. Any help is appreciated. thanks MS sql, query - Original Message - From: Victoria Reznichenko [EMAIL PROTECTED

Re: mysql dump for remote db

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

Re: mysql dump for remote db

On Tue, Jan 28, 2003 at 10:19:19AM -0700, Mark Stringham wrote: Does anyone have a suggestion as to how I could run a periodic mysql dump for a db that is hosted remotely - IE a web host. I do know that this host does not support crons. Any help is appreciated. If you have access

Re: mysql dump for remote db

Please don't hijack threads. In the last episode (Jan 28), Mark Stringham said: Does anyone have a suggestion as to how I could run a periodic mysql dump for a db that is hosted remotely - IE a web host. I do know that this host does not support crons. Just cron mysqldump -h webhostmachine

mysql dump not working

sql, query I'm trying to utilize the mysqldump utility to backup my db on a WIN2k advanced server. I'm running a BAT file with the following syntax c:\apache\mysql\binmysqldump -u uipcontent -p test c:\testdump.sql the file testdump.sql gets created in the appropriate place but the

mysql dump not working

sql, query I'm trying to utilize the mysqldump utility to backup my db on a WIN2k advanced server. I'm running a BAT file with the following syntax c:\apache\mysql\binmysqldump -u uipcontent -p test c:\testdump.sql the file testdump.sql gets created in the appropriate place but the

Re: mysql dump not working

I'm not sure what you mean but the file gets created and when I open it - there is nothing in it. Do I need the path to mysql at the beginning ? IE c:\apache\mysql\binmysqldump ? thanks MS On Fri, Jan 17, 2003 at 04:12:58PM -0700, Mark Stringham wrote: sql, query I'm trying to

Re: mysql dump not working

I'm not sure what you mean but the file gets created and when I open it - there is nothing in it. Do I need the path to mysql at the beginning ? IE c:\apache\mysql\binmysqldump ? thanks MS On Fri, Jan 17, 2003 at 04:12:58PM -0700, Mark Stringham wrote: sql, query I'm trying to

Re: mysql dump not working

On Fri, Jan 17, 2003 at 04:24:37PM -0700, Mark Stringham wrote: I'm not sure what you mean but the file gets created and when I open it - there is nothing in it. Do I need the path to mysql at the beginning ? IE c:\apache\mysql\binmysqldump ? Hi Mark, To rephrase: If you run the

Re: mysql dump not working

On Fri, Jan 17, 2003 at 04:12:58PM -0700, Mark Stringham wrote: sql, query I'm trying to utilize the mysqldump utility to backup my db on a WIN2k advanced server. I'm running a BAT file with the following syntax c:\apache\mysql\binmysqldump -u uipcontent -p test c:\testdump.sql

Re: mysql dump not working

At 16:27 -0700 1/17/03, Zak Greant wrote: On Fri, Jan 17, 2003 at 04:24:37PM -0700, Mark Stringham wrote: I'm not sure what you mean but the file gets created and when I open it - there is nothing in it. Do I need the path to mysql at the beginning ? IE c:\apache\mysql\binmysqldump ? Hi

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)

RE: Using PHP to do a MySql Dump

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

Re: Using PHP to do a MySql Dump

Upon initial search, does not appear to be. except: exec(mysqldump) or system(), or shell_exec() Maybe the PHP list would render better results? HTH -Brad Todd Cary wrote: Is there a function that can be implemented with PHP to do the equivalent of a mysqldump? Todd -- Ariste Software,

Re: Using PHP to do a MySql Dump

AFAIK, there is no built-in function in PHP for a dump. That's at least what the manual says. An alternative is to use a system call e.g. system() or exec() with mysqldump. Hope that helps, Claudia From Todd Cary [EMAIL PROTECTED] on Fri, Dec 20, 2002 at 08:35:02AM -0800 Is there a function

RE: Mysql dump error

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

re: Mysql dump error

Dan, Thursday, November 07, 2002, 9:11:10 AM, you wrote: DR mysqldump: Got error: 1030: Got error 127 from table handler when retrieving DR data DR from server DR for some reason i get this when i dump all databases DR using mysqldump -p --all-databases --add-drop-table --quote-names DR

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

Re: MySQL dump/recovery probable bug

On Friday, 21. June 2002 15:43, Stefano Incontri wrote: Hi, I found the following problem, which I consider a bug, but maybe I'm missing something to make it work correctly. This is not a bug. Why do you use a reserved word (LOAD) for an index name?! Rename it and everything should be ok.

Re: MySQL dump/recovery probable bug

Hi! Georg == Georg Richter [EMAIL PROTECTED] writes: Georg On Friday, 21. June 2002 15:43, Stefano Incontri wrote: Georg Hi, I found the following problem, which I consider a bug, but maybe I'm missing something to make it work correctly. Georg This is not a bug. Why do you use a

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

Re: MySQL dump/recovery probable bug

On Friday 21 June 2002 09:54, Keith C. Ivey wrote: On 21 Jun 2002, at 15:43, Stefano Incontri wrote: ERROR 1064: You have an error in your SQL syntax near 'Load (IL,Item_ID) ) TYPE=MyISAM COMMENT='SCM Internal Loads table'' at line 12 LOAD is a reserved word in MySQL, so you need backticks

RE: MySQL dump/recovery - no bug at all

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

RE: mySQL dump

* On-Site I'm very new to mySQL and have what is probably a simple question. I've created my database using mySQL and it resides on my local PC. I want to upload it to my hosting service's server. They tell me You would dump the content of your mysql database on your local machine and then

  1   2   >