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
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 a
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
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 howev
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 mysq
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.
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
> 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 have tried
> so hard to get it t
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
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. Onc
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, m
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
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
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
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'
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,
He
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}/${databas
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]
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
>
>
> I have a bit of an issue wit
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.
>
> Granted, I have 1 table that has over 1Millio
-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
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
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
-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 "mysqldump -h webhostmachine
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
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 yo
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
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>
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`
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
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-name
* 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 an
Uma Shankari T queried:
> I am having all mysql database contents in one txt file.how i will dump
> all those contents to mysql database tablespls tell me how to do it
Have you looked at the manual, section 4.8.7?
mysqlimport
Joel Rees
Alps Giken Kansai Systems Develoment
Suita, Osaka
on 3/13/01 12:41 AM, Gilles Dumangin at [EMAIL PROTECTED] wrote:
> I would like to extract the contents of a database to use it in a ASCII
> format. It is a addresses database and I want to use it in Excel. I have
> tried Mysqldump but it gives me the CREATE and INSERT statements all the
> time.
That's what mysqldump does. Try using a SELECT statement with an outfile.
Check the manual, chapter 7, the part about SELECT for details.
Cal
http://www.calevans.com
-Original Message-
From: Gilles Dumangin [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 13, 2001 1:42 AM
To: [EMAIL PRO
61 matches
Mail list logo