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 com
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
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.
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
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
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
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
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=la
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=passwo
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
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
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
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=
.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
&g
nt 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
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
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.
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
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 ter
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 Sh
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
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 a
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
> 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
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 discove
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
>
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 chan
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
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
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
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
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
Hey y'all,
I use charming Windows XP on here. I've taken database
classes but lucky for me we never used *real* MySQL.
Below I typed up exactly what I put into the MySQL
prompt and this is what it kicks back to me.
Lillian
mysql>
mysql> \R shell>
PROMPT set to 'shell>'
shell>
shell>mysqldu
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
mysqldump -u -p -q --single-transaction --tab=/dest/dir database
or
mysql -u root -p database > output.sql
On Tue, July 24, 2007 03:16, Red Hope wrote:
> Hey y'all,
> I've been fussing with the MySQL dump procedure to
> backup my stuff. I'm on MySQL 5.0.41 and I hav
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 swi
> >
> > --- 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
> >
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 proced
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
&
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 M
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
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
bi
t; <[EMAIL PROTECTED]>
To:
Sent: Wednesday, March 08, 2006 1:17 PM
Subject: Restoring a database from a complete MySQL dump
I have a MySQL 4.1.x installation. It was upgraded to MySQL 5.0.x and then
downgraded again, back to 4.1.14. I took a complete dump of all
databases/tables into a .sql file,
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
[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;
[/s
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',
`quo
[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
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
[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
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 < backu
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 use
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 dum
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:
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 pas
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/o
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:/
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'
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.
tml
- 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 utili
ckup_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 Co
>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 or
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 -ppas
I tried doing this when I first got MySQL installed on the new machine, but when I did
"SHOW DATABASES;" through mysql it was not listed. Is there something I need to do to
let MySQL know that the database is there?
Ryan Sinnwell
Regional IT Engineer
The Weitz Company
515-698-4281
515-229-5517
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]
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
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
<[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
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
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 m
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
>
>
>
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 bi
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.
>
> Gra
I have a bit of an issue with mysqldumps and inserting it back into
mysql.
Granted, I have 1 table that has over 1Million entries, but generating
these tables takes about 3 hours with a java app.
But when I do a mysql -u root -p < it is taking
about 28 hours to complete the load.
Can anyone te
-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 b
;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
;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
-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
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
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
:
> 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.
>
>
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&quo
At 16:27 -0700 1/17/03, Zak Greant wrote:
On Fri, Jan 17, 2003 at 04:24:37PM -0700, Mark Stringham wrote:
I'm not sure what you mean but the file gets created and when I open
it - there is nothing in it.
Do I need the path to mysql at the beginning ? IE
c:\apache\mysql\bin>mysqldump ?
Hi
On Fri, Jan 17, 2003 at 04:12:58PM -0700, Mark Stringham wrote:
> sql, query
>
> I'm trying to utilize the mysqldump utility to backup my db on a WIN2k
> advanced server. I'm running a BAT file with the following syntax
>
> c:\apache\mysql\bin>mysqldump -u uipcontent -p test >
> c:\testdum
On Fri, Jan 17, 2003 at 04:24:37PM -0700, Mark Stringham wrote:
> I'm not sure what you mean but the file gets created and when I open
> it - there is nothing in it.
>
> Do I need the path to mysql at the beginning ? IE
> c:\apache\mysql\bin>mysqldump ?
Hi Mark,
To rephrase: If you run the
I'm not sure what you mean but the file gets created and when I open
it - there is nothing in it.
Do I need the path to mysql at the beginning ? IE
c:\apache\mysql\bin>mysqldump ?
thanks
MS
> On Fri, Jan 17, 2003 at 04:12:58PM -0700, Mark Stringham wrote:
> > sql, query
> >
> > I'm trying
I'm not sure what you mean but the file gets created and when I open
it - there is nothing in it.
Do I need the path to mysql at the beginning ? IE
c:\apache\mysql\bin>mysqldump ?
thanks
MS
> On Fri, Jan 17, 2003 at 04:12:58PM -0700, Mark Stringham wrote:
> > sql, query
> >
> > I'm trying
sql, query
I'm trying to utilize the mysqldump utility to backup my db on a WIN2k
advanced server. I'm running a BAT file with the following syntax
c:\apache\mysql\bin>mysqldump -u uipcontent -p test >
c:\testdump.sql
the file testdump.sql gets created in the appropriate place but the
fi
sql, query
I'm trying to utilize the mysqldump utility to backup my db on a WIN2k
advanced server. I'm running a BAT file with the following syntax
c:\apache\mysql\bin>mysqldump -u uipcontent -p test >
c:\testdump.sql
the file testdump.sql gets created in the appropriate place but the
fi
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
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 Softwa
ject: 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
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://li
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>
ectroteque.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-
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
--
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
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.
efault?
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
>
>
>
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 b
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
1 - 100 of 123 matches
Mail list logo
