We will tend to use binary backups (Xtrabackup) for full consistent dataset
restore (think slave provisioning and disaster recovery) and logical
backups to perform single table restores in the event that a rollback may
need to occur if someone drops a table or carries out an insane update. We
will
Maybe no, as you knew.
> It means that after lock is released, dump is made while the read and
write
> activity is going on. This dump then, would be inconsistent.
Not only binary logs, each tables in your dump is based the time when
mysqldump began to dump *each* tables.
It means, for example,
So, in case of * NOT Innodb * storage engine, say MyISAM, will this dump be
of any useful?
Best Regards,
Geetanjali Mehra
Senior Oracle and MySQL DBA Corporate Consultant and Database Security
Specialist
On Tue, Oct 7, 2014 at 11:55 AM, yoku ts. wrote:
> Hello,
>
> If you use any *NOT InnoDB*
Hello,
If you use any *NOT InnoDB* storage engine, you're right.
mysqldump with --single-transaction doesn't have any consistent as you say.
If you use InnoDB all databases and tables, your dumping process is
protected by transaction isolation level REPEATABLE-READ.
http://dev.mysql.com/doc/refm
It seems to me that once the read lock is acquired, only the binary log
coordinates are read. Soon after binary log coordinates are read, lock is
released. Is there anything else that happens here?
It means that after lock is released, dump is made while the read and write
activity is going on.
Hello Geetanjali,
On 9/23/2014 7:14 AM, geetanjali mehra wrote:
Can anybody please mention the internals that works when we use mysqldump
as follows:
*mysqldump --single-transaction --all-databases > backup_sunday_1_PM.sql*
MySQL manual says:
This backup operation acquires a global read lock
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: Mysqldump routines dump, problem
On Tue, 20 Nov 2012, Ricardo Barbosa wrote:
Hi all.
I'm trying to do a recover on a table for a client, with the following message
root@falcon:~# mysqldump -u root -pXXX database
-- MySQL dump 10.13 Distrib 5.1.30, for pc-linux-gnu (i686)
--
-- Host: localhost Database: database
-- --
mysqldump --databases test --tables ananda > test.dmp
mysql> show create table ananda\G;
*** 1. row ***
Table: ananda
Create Table: CREATE TABLE `ananda` (
`id` int(11) DEFAULT NULL,
`name` varchar(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT
Are you using an abnormal CHARACTER SET or COLLATION?
SHOW CREATE TABLE
Show us the args to mysqldump.
> -Original Message-
> From: James W. McNeely [mailto:j...@newcenturydata.com]
> Sent: Friday, June 15, 2012 10:19 AM
> To: mysql@lists.mysql.com
> Subject: mysqldump not escaping single
I have mysql 5.5.
I am able to use mysqldump to export data with quotes and the dump had
escape character as seen below
LOCK TABLES `ananda` WRITE;
/*!4 ALTER TABLE `ananda` DISABLE KEYS */;
INSERT INTO `ananda` VALUES
(1,'ananda'),(2,'aditi'),(3,'thims'),(2,'aditi'),(3,'thims'),(2,'aditi'),(3
@lists.mysql.com
Subject: Re: mysqldump: Got error: 1017: Can't find file:
'./ssconsole/ss_requestmaster.frm' (errno: 24) when using LOCK TABLES
Hello Shafi,
Adding to Prabhat alternatives, you can use --force to the mysqldump command
to ignore the errors and continue taking backup.
Rega
Hello Shafi,
Adding to Prabhat alternatives, you can use --force to the mysqldump command
to ignore the errors and continue taking backup.
Regarding the error, we need to check whether the table is present or not
and the engine type specifically.
Thanks
Suresh Kuna
On Sat, Sep 24, 2011 at 3:31
correct. mysqldump by default has --lock-tables enabled, which means it
tries to lock all tables to be dumped before starting the dump. And doing
LOCK TABLES t1, t2, ... for really big number of tables will inevitably
exhaust all available file descriptors, as LOCK needs all tables to be
opened.
In the last episode (Sep 23), Shafi AHMED said:
> I have a mysql database of 200G size and the backup fails due to the foll.
> Issue.
>
> mysqldump: Got error: 1017: Can't find file:
> './ssconsole/ss_requestmaster.frm' (errno: 24) when using LOCK TABLES
>
> Can someone assist pls.?
$ perror 24
Someone seems to have deleted that file, which contains the description of the
corresponding table. Recreate the exact same table (EXACT, including keys,
indices, datatypes, encoding, the lot) and copy that tables's .frm file to
replace the lost one. Then pray to the elder gods and restart your
Hi Daniel,
you can use a workaround from the shell,
cd /path/to/your/database (e.g.: cd /var/lib/mysql/mydb)
ls -al *table** | awk '{print $8}' | awk -F"." '{print "--ignore-table=*mydb
*."$1}' | xargs mysqldump -u*root* -p*toor* *--your-flags **mydb*
It's not that beautiful but it should work
you can use "--ignore-table" option for this,
mysqldump -u -p dbname --ignore-table=dbname.tablename > xyz.sql
you can use this option multiple times to ignore multiple tables.
Rgds,
Jay
On Tue, Jan 18, 2011 at 6:18 PM, Adarsh Sharma wrote:
> Dear all,
>
>
> I am researching about diffe
Check the manual? Its here under ignore-table
http://dev.mysql.com/doc/refman/5.1/en/mysqldump.html
Quoting Adarsh Sharma :
Dear all,
I am researching about different parameters provided by the
*mysqldump* utility.
It provides a method to dump databases with all tables.
My problem is I w
In the last episode (Jan 12), Feighen Oosterbroek said:
> I know that this is a bit of a vague question, but over a period of days
> mysqldump will take on one day 2min to complete and on the following day
> 25min to complete, with the resulting sql file being maybe 200M bigger.
> The dataset isn'
Appreciate any help on this.
Any alternative of mysqldump is also fine with me to take backup while
restricting root login access from localhost only.
Thanks in advance.
Regards,
Tanmay
On Wed, Oct 20, 2010 at 10:14 AM, Tanmay Pradhan wrote:
> Yes, r...@localhost entry is still present in user
Yes, r...@localhost entry is still present in user table. Only
root@'%' is deleted. So it's not obvious to fail.
Hi yu.zou,
The r...@localhost entry already had all privileges, except this entry
had empty password column.
u...@localhost entry before GRANT
+---
Hellpo Krishna,
On 10/19/2010 8:40 AM, Krishna Chandra Prajapati wrote:
Hi Pradhan,
Obviously, it should fail. Since you have deleted the root user which is
used by mysqldump for making connection to mysql server for taking backup
Not true. The utility mysqldump is just a client like any oth
Of course you know you did not delete r...@localhost, just root @ '%'
which generally should not matter to mysqldump.
What I suspect is the issue here is that the database you are trying
to dump contains procedures/methods that were defined by a user while
logged in as root@'%'. If you recreate t
Hi Pradhan,
Obviously, it should fail. Since you have deleted the root user which is
used by mysqldump for making connection to mysql server for taking backup
Krishna
CGI.COM
On Tue, Oct 19, 2010 at 11:06 AM, Tanmay Pradhan wrote:
> Hi,
>
> I am using the following version of MySQL on my Mac
I'm not sure but you might try with sql_mode set to ANSI. Otherwise try the
dump
remotely from a Linux box.
Regards,
Nitin
From: Manasi Save
To: win.a
Cc: "mysql@lists.mysql.com"
Sent: Wed, September 8, 2010 3:57:40 PM
Subject: Re: mysql
Hi win.a,
I tried with another user the problem still persists. I am getting same
error for another user as well.
--
Regards,
Manasi Save
On Tue, 7 Sep 2010 11:41:35 0800, "win.a" wrote:
use another user and dump the data ,eg the root .
> mysqldump -uroot -p --al-databases >AllNew_Databa
No it does not. But when I dump database name "mydb" it does. but not
the database with name "1".
--
Regards,
Manasi Save
On Mon, 06 Sep 2010 09:23:21 0200, Jangita wrote:
On 06/09/2010 6:54 a, Manasi Save wrote:
> > Dear Nitin,
> >
> > I have newly installed mysql on this server.
> >
On 06/09/2010 6:54 a, Manasi Save wrote:
Dear Nitin,
I have newly installed mysql on this server.
mysql> Select version();
+-+
| version() |
+-+
| 5.1.22-rc-Debian_2~ppa5-log |
+-+
Earlier I use to run the same
Dear Nitin,
I have newly installed mysql on this server.
mysql> Select version();
+-+
| version() |
+-+
| 5.1.22-rc-Debian_2~ppa5-log |
+-+
Earlier I use to run the same command on Fedora-wi
Hi,
Have you recently upgraded your MySQL installation? 1064 in earlier days used
to
mean use of reserved word. Few clients have reported this error in last couple
of months after they upgraded from 5.1.41 to higher versions. As of now, I
don't
have a solution other than changing the name (of
>-Original Message-
>From: Raj Shekhar [mailto:rajl...@rajshekhar.net]
>Sent: Friday, May 28, 2010 2:40 PM
>To: mysql@lists.mysql.com
>Cc: mysql@lists.mysql.com
>Subject: Re: mysqldump backup
>
>In infinite wisdom Angelina Paul wrote:
>
>> [1 ]
>>
In infinite wisdom Angelina Paul wrote:
> [1 ]
> I looking for a way to corrupt a mysql database forcefully for testing
> purpose
> and then the mysqldump utility will fail for taking backup against it.
kill -9 MYSQLD_PID while the backup is running should give you an
indication.
--
Raj Shek
I looking for a way to corrupt a mysql database forcefully for testing
purpose
and then the mysqldump utility will fail for taking backup against it.
On Fri, May 28, 2010 at 8:06 AM, Anand.S wrote:
> redirect your standard errors to some log file..
>
> mysqldump --all-databases --flush-logs --ma
redirect your standard errors to some log file..
mysqldump --all-databases --flush-logs --master-data=2 >
/bk01/all_databases_`date +%a`.sql 2> /tmp/test.log
i follow the above syntax for logging the errors in my script.
Thanks
Anand
On Fri, May 28, 2010 at 5:44 PM, Angelina Paul wrote:
> Cou
On 3/4/10 7:21 PM, "peng yao" wrote:
> hello erveryone, I have a question about mysqldump.I have some blob data,
> someone tell me mysqldump the data must use "hex-blob" options, why?
mysqldump just creates a file containing insert statements that when
executed rebuild your tables. As a resul
hi there, thanks for your reply.
the mysql server is running on windows xp sp3, every time I use root user to
log in.
the command line i use for mysqldump is
mysqldump --user=root --password=pass test>test.sql
phpmyadmin is with following checked
Add DROP TABLE / VIEW / PROCEDURE / FUNCTION /
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 is by no means the fastest way to move data between systems.
For a bulk job of this magnitude, try this:
http://dev.mysql.com/doc/refman/5.1/en/load-data.html
- michael dykman
On Wed, Oct 14, 2009 at 3:59 AM, Claudio Nanni wrote:
> We dumped a mysql 4.1.22 database using the mysqld
Hi Matt,
The error you are getting is very particular to "information_schema"
database.
Information_schema does NOT actually have tables, they are views:
"|INFORMATION_SCHEMA| is the information database, the place that stores
information about all the other databases that the MySQL server
If you look at the options for mysqldump more closely, you will see
that you can specify the version of the server which will be importing
the result file. These cause MySQL to taylor the SQL syntax according
to the target platform.
- michael dykman
On Wed, Sep 2, 2009 at 11:03 AM, Matt Neimeye
ok, i see
now the resultings files are owned by mysql.
every file has the same user granted, but the wrong one since
i can not chown user.group * as normal user.
So far i see it is the same problem as with "select into outfile"
Is there a fancy trick for mysqldump so i will create the correspondi
you also can do this:#sudo -u mysql "mysqldump command"
or
#su - mysql -c "mysqldump command"
2009/7/24 walter harms
>
>
> muhammad subair schrieb:
> > On Thu, Jul 23, 2009 at 10:10 PM, walter harms wrote:
> >
> >> Hi list,
> >> i use mysqldump --tab to create database dumps. this will prod
muhammad subair schrieb:
> On Thu, Jul 23, 2009 at 10:10 PM, walter harms wrote:
>
>> Hi list,
>> i use mysqldump --tab to create database dumps. this will produce txt and
>> sql files.
>> the resulting sql files is owned by the user but the resulting datafile is
>> owned by mysql.mysql
>> is
# chown mysql.mysql datafile
2009/7/23 walter harms
> Hi list,
> i use mysqldump --tab to create database dumps. this will produce txt and
> sql files.
> the resulting sql files is owned by the user but the resulting datafile is
> owned by mysql.mysql
> is there any way to change that ?
>
> r
#mysqldump -u username -p -h mysqld_host databasename > database_name.sql
username is the mysqld server login name
mysqld_host is the mysqld server address or hostname
databasename is the database which you should dump
You can use "man mysqldump" or "mysqldump --help" to get more infomation
2009/
we need more information,
such as your client and server version, the command that exactly your input
etc.
2009/7/14 JingTian
> hi all,
>
> i use mysqldump to backup my database,
> the command line is; mysqldump -p -u -h database_name > database_name.sql
>
> i find in the database_name.sql, ther
MySQL dump calls LOCK TABLES before dumping the data (presumably to
prevent data modification halfway through the process).
LOCK TABLES has its own privilege (conveniently given the same name)
which your user account will have to be given in order to run a
mysqldump.
On Fri, 2009-05-01 at 15:49 +
actually, that was stupid of me - you need a list of tables not files.
I think the only to do this, and the way we do it, is to run some command
like:
mysql -e"show tables in db-name like 'z%'" >tabnames
Note the use of double-quotes and single-quotes.
then use a loop to read the file "tabnames"
>> Date: Sun, 19 Apr 2009 16:29:48 +0200
>> From: m...@kiewel-online.ch
>> To: saeho...@hotmail.com
>> CC: mysql@lists.mysql.com
>> Subject: Re: mysqldump syntax - dumping only specific tables starting
> with a certain character. (e.g. z*)
>>
>> -BEGI
me. Plz tell me what I've done wrongly this time. :)
> Date: Sun, 19 Apr 2009 16:29:48 +0200
> From: m...@kiewel-online.ch
> To: saeho...@hotmail.com
> CC: mysql@lists.mysql.com
> Subject: Re: mysqldump syntax - dumping only specific tables starting with a
> certain
s' mean? (as in linux command 'ls'?)
you have to use the ` sign, not the '
Uwe
>
> :)
>
>
>> Date: Sun, 19 Apr 2009 08:53:36 -0500
>> Subject: Re: mysqldump syntax - dumping only specific tables starting with a
>> certain character. (e.
I tried it, then it gives the following error message
mysqldump: Can't get CREATE TABLE for table 'ls z*' (Table '(db-name).ls z*'
doesn't exist)
What does 'ls' mean? (as in linux command 'ls'?)
:)
> Date: Sun, 19 Apr 2009 08:53:36
try something like:
mysqldump -u(user) -p (db-name) `ls z*` > (filename)
2009/4/19 ChoiSaehoon
>
> Is there a way to dump only specific tables starting with a certain
> character?
>
>
>
> For example, I only want to dump tables starting with the character 'z'.
>
> The following doesn't work.
>
I wanted to respond with what I found:
APPARMOR blocks mysql from writing to any other directory than the data
dir and /tmp.
I had to edit the /etc/apparmor.d/usr.sbin.mysqld file and add the
following:
/backups/mysql** rwk,
to the bottom.
Hope this helps someone.
Ray
--
MySQL General
Hi,
On Thu, Apr 2, 2009 at 1:18 PM, Virgilio Quilario
wrote:
>> Hi,
>>
>> MySQL v4.1.22 on Linux 2.6.18-6-686
>>
>> I have a dump file generate with mysqldump created by a version 4.1.10
>> server.
>>
>> I want to import the dump file into a different server. When I run
>>
>> mysqldump --databas
> Hi,
>
> MySQL v4.1.22 on Linux 2.6.18-6-686
>
> I have a dump file generate with mysqldump created by a version 4.1.10 server.
>
> I want to import the dump file into a different server. When I run
>
> mysqldump --database mydb --debug < mydumpfile.sql
>
> I get the following:
>
> -- MySQL dump 1
On Tue, Jan 13, 2009 at 6:06 PM, Dan wrote:
> On Tue, 13 Jan 2009 18:34:44 -0600, Andrew Garner
> wrote:
>
>> This sounds like you need to raise max_allowed_packet for mysqldump
>> (and possibly mysqld) - these are separate settings for both the
>> client and the server. You can do this via the
On Tue, 13 Jan 2009 18:34:44 -0600, Andrew Garner
wrote:
> This sounds like you need to raise max_allowed_packet for mysqldump
> (and possibly mysqld) - these are separate settings for both the
> client and the server. You can do this via the my.cnf (or ~/.my.cnf)
> or specify it as an option on
This sounds like you need to raise max_allowed_packet for mysqldump
(and possibly mysqld) - these are separate settings for both the
client and the server. You can do this via the my.cnf (or ~/.my.cnf)
or specify it as an option on the command line "mysqldump --opt ...
--max_allowed_packet=1G dbna
On Tue, 2009-01-13 at 12:19 +0530, Chandru wrote:
> Hi,
>
> Did u try using this command
>
>
> mysqldump --opt db_name > db_name.sql -p 2>>bkp.err
Not quite. Firstly, I had to alter the normal backup cron job, and that
doesn't happen until late at night.
Secondly, yes I added the redirecti
I'm also having a similar issue with some tables I've been trying to dump
(total data set is around 3TB). I'm dumping directly from one host to
another (mysqldump -hSOURCE DATABASE | mysql -hLOCALHOST DATABASE) using
mysql 4.1.22. One system is Solaris 10 SPARC, while the other is Solaris 10
x64
On Mon, 12 Jan 2009 16:25:12 +0530, Chandru wrote:
> Hi,
>
> please increase your interactive_timeout variable to some big number and
> also try to log the erros if any thing by using the command:
>
> mysqldump --opt db_name > db_name.sql -p 2>>bkp.err
>
> check if you get some thing in the b
Hi,
please increase your interactive_timeout variable to some big number and
also try to log the erros if any thing by using the command:
mysqldump --opt db_name > db_name.sql -p 2>>bkp.err
check if you get some thing in the bkp.err file.
Regards,
Chandru,
www.mafiree.com
On Mon, Jan 12, 20
Hi Nanu,
According to me
You could use
1. --result-file=file, -r file
2. > file (complete path or present working directory would be the place
where your file would be saved)
Since you are not mentioning the output to be in any different format apart
from SQL, it would be a sql file. You can na
What is your storage engine used?
On Fri, Nov 21, 2008 at 8:59 AM, Marten Lehmann <[EMAIL PROTECTED]> wrote:
> Hello,
>
> what do these errors mean:
>
> mysqldump: Got error: 1030: Got error 1 from storage engine when using LOCK
> TABLES
> mysqldump: Couldn't execute 'show create table `Antrag`':
What is your storage engine used?
On Fri, Nov 21, 2008 at 8:59 AM, Marten Lehmann <[EMAIL PROTECTED]> wrote:
> Hello,
>
> what do these errors mean:
>
> mysqldump: Got error: 1030: Got error 1 from storage engine when using LOCK
> TABLES
> mysqldump: Couldn't execute 'show create table `Antrag`':
Show the details of your hardware us.
On Thu, Oct 2, 2008 at 3:02 PM, Krishna Chandra Prajapati <
[EMAIL PROTECTED]> wrote:
> Hi,
>
> Just try the below command on console. It will give that the error is
> exactly related to what.
>
> $perror 5
>
> What is total ram in your box.
>
>
> On Thu, Oct
Hi,
Just try the below command on console. It will give that the error is
exactly related to what.
$perror 5
What is total ram in your box.
On Thu, Oct 2, 2008 at 12:26 PM, Uma Bhat <[EMAIL PROTECTED]> wrote:
> Hey Guys!
>
> I have been googling a lot on this error and read various suggestion
Thanks!
Nanu
>>> <[EMAIL PROTECTED]> 23/08/2008 09:50:13 >>>
Whatever you name it
Wherever you place it
Mysqldump (options) > filename
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Whatever you name it
Wherever you place it
Mysqldump (options) > filename
--Original Message--
From: Nanu Kalmanovitz
Sender:
To: mysql@lists.mysql.com
Sent: Aug 22, 2008 23:48
Subject: mysqldump questions
Hi!
What is the name dumped file and where it is created?
System is :Novell 6
Cc: mysql@lists.mysql.com
Subject: Re: mysqldump
[EMAIL PROTECTED] mysqldump -u jpaulo -paivalf -h 200.18.142.98 genweb
-- MySQL dump 10.11
--
-- Host: 200.18.142.98Database: genweb
-- --
-- Server version 4.0.18-log
/*!40103 SET @OLD_TIME_ZONE=@
300
> From: [EMAIL PROTECTED]
> To: [EMAIL PROTECTED]
> Subject: Re: mysqldump
> CC: mysql@lists.mysql.com
>
> [EMAIL PROTECTED] mysqldump -u jpaulo -paivalf -h 200.18.142.98 genweb
> -- MySQL dump 10.11
> --
> -- Host: 200
[EMAIL PROTECTED] mysqldump -u jpaulo -paivalf -h 200.18.142.98 genweb
-- MySQL dump 10.11
--
-- Host: 200.18.142.98Database: genweb
-- --
-- Server version 4.0.18-log
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+
In the last episode (Jul 26), John Nietzsche said:
> i am in need to migrate a database between two mysql server. The
> server source is running mysql 4.0.18-log, the destination server is
> running mysql 5.0.51a-log.
>
> I dumped the database (in the server source) using mysqldump utility.
> The
In the last episode (Jul 02), Martin Gainty said:
>
> How do I get mysqldump to turn off quotes e.g from
> INSERT INTO "table"
> to
> INSERT INTO table
http://dev.mysql.com/doc/refman/5.0/en/mysqldump.html#option_mysqldump_quote-names
--
Dan Nelson
[EMAIL PROTECTED]
--
MySQL
>
> - Original Message -
> *From:* Moon's Father <[EMAIL PROTECTED]>
> *To:* [EMAIL PROTECTED]
> *Cc:* mysql@lists.mysql.com
> *Sent:* Saturday, June 21, 2008 12:20 PM
> *Subject:* Re: mysqldump giving errors
>
> Maybe you have to adjust your file limit
ne 21, 2008 12:20 PM
Subject: Re: mysqldump giving errors
Maybe you have to adjust your file limit by user named mysql.
On Sat, Jun 21, 2008 at 7:50 PM, <[EMAIL PROTECTED]> wrote:
Hi All,
I am running mysqldump with --no-data option, but it gives error:
"can't e
Maybe you have to adjust your file limit by user named mysql.
On Sat, Jun 21, 2008 at 7:50 PM, <[EMAIL PROTECTED]> wrote:
> Hi All,
>
> I am running mysqldump with --no-data option, but it gives error:
> "can't exec 'show fields from ...' out of resources when opening file ...
> (errorcode 24) (2
If you create all your databases and tables with utf8,then every thing is
fine.
On Mon, Apr 28, 2008 at 1:43 AM, Velen <[EMAIL PROTECTED]> wrote:
> Hi,
>
> I'm storing some ascii codes in a table. When I do a dump using mysqldump
> from the server and then restoring it on another station, the as
Thanks. That sounds pretty labor intensive, since I'd have to do the copy
for each table. That makes the process much harder to automate. And I'm not
sure the end result would be what I wanted anyway. I would like to be able
to do this without copying data around. Does anybody have another
suggesti
You can import your data into a test database,then export the data using
statement select ... into ...
then You can complare the two.
On Tue, May 20, 2008 at 9:14 AM, Dan Lipsitt <[EMAIL PROTECTED]> wrote:
> Is there a set of flags for mysqldump that will include the auto_increment
> specifier fo
use can say mysqldump --help, it would give you all the options.
To speedup the dump, you can use -e -q and --single-transaction,
regards
anandkl
On 4/16/08, minky arora <[EMAIL PROTECTED]> wrote:
>
> Thanks.
> I will successful in executing LOAD DATA INFILE>
>
> Now i need to do a SqlDump as w
Am Dienstag, den 15.04.2008, 15:11 -0400 schrieb minky arora:
> Could someone pls guide me as to the best way of adding excel files as
> tables to Mysql ?
You can import CSV files into MySQL:
http://dev.mysql.com/doc/refman/5.1/en/load-data.html
Norbert
--
MySQL General Mailing List
Fo
On Tue, Apr 15, 2008 at 3:11 PM, minky arora <[EMAIL PROTECTED]> wrote:
> Hi Gurus,
> I am a newbie.Please bear with me.
> Could someone pls guide me as to the best way of adding excel files as
> tables to Mysql ?
mysqldump is for exporting data. What you're looking for is the
"LOAD DATA [
> MySQL does provide LOAD DATA INFILE
> (http://dev.mysql.com/doc/refman/5.0/en/load-data.html), but I was
> hoping to do it through mysqldump instead of SELECT INTO because I
> assumed the performance was faster. If that's not the case, though,
> I'll go ahead and use SELECT INTO OUTFILE and
Thanks for the responses, Inline:
On Sun, Mar 9, 2008 at 7:49 PM, Tim McDaniel <[EMAIL PROTECTED]> wrote:
> > On Sat, Mar 8, 2008 at 11:55 PM, Waynn Lue <[EMAIL PROTECTED]> wrote:
> >> Subject: Re: mysqldump on specific columns only?
>
> >> I'm tryin
On Sat, Mar 8, 2008 at 11:55 PM, Waynn Lue <[EMAIL PROTECTED]> wrote:
Subject: Re: mysqldump on specific columns only?
I'm trying to dump all the columns of a table but one in a
restructuring of my schema.
By "dump", I assume you mean "output", not "delete&q
On Sat, Mar 8, 2008 at 11:55 PM, Waynn Lue <[EMAIL PROTECTED]> wrote:
> I'm trying to dump all the columns of a table but one in a
> restructuring of my schema. I found this post:
> http://www.jsw4.net/info/listserv_archives/mysql/05-wk49/msg00131.html
> which seems to indicate that this isn't
Mike Spreitzer wrote:
Sorry if I have confused people by presenting
evidence in the wrong order. Also, it seems that the .sql file is
written by the client while the .txt file is (attempted to be) written
by the server. Here is a single typescript with all the evidence:
[EMAIL PROTECTED] ~]
.00$ ls -l
total 16
-rw-r--r-- 1 mysql mysql 29 Feb 22 20:46 foo.bar
-rw-r--r-- 1 root root 742 Feb 22 20:46 red1_p2.sql
-bash-3.00$
Thanks,
Mike
Jed Reynolds <[EMAIL PROTECTED]>
02/22/08 07:24 PM
Please respond to
[EMAIL PROTECTED]
To
Mike Spreitzer/Watson/[EMAIL PROTECTED]
cc
what happens when you delete the files that are already in there? Looks
like you're dumping to a file owned by root.
Jed
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
19:11 red1_p2.sql
[EMAIL PROTECTED] /]#
Thanks,
Mike
Jed Reynolds <[EMAIL PROTECTED]>
02/22/08 07:04 PM
Please respond to
[EMAIL PROTECTED]
To
Mike Spreitzer/Watson/[EMAIL PROTECTED]
cc
mysql list
Subject
Re: mysqldump: Got error: 1: Can't create/write to file
'dumpdir/ta
Mike Spreitzer wrote:
So I am trying to use mysqldump --tab for the first time. I am running
into the same problem everybody does on their first try --- Errcode: 13. I
have set the permissions on the target directory to be completely liberal
--- anybody can do anything with it --- and I still
"Maybe too much data is being pumped in through the pipe"
This sounds spot on. I redid the command to take the pipe out of the
equation and it seems to be working now. Thanks for the feedback.
Rolando Edwards-3 wrote:
>
> 'errno 32 on write'
>
> That's a broken pipe error (Run 'perror 32' i
Hi,
On Dec 4, 2007 2:58 PM, Rolando Edwards <[EMAIL PROTECTED]> wrote:
> 'errno 32 on write'
>
> That's a broken pipe error (Run 'perror 32' in Linux)
> Maybe too much data is being pumped in through the pipe.
>
> Instead of this :
> /usr/bin/mysqldump --all-databases -u root | /usr/bin/gzip -c
>
'errno 32 on write'
That's a broken pipe error (Run 'perror 32' in Linux)
Maybe too much data is being pumped in through the pipe.
Instead of this :
/usr/bin/mysqldump --all-databases -u root | /usr/bin/gzip -c
/backups/mysql_backup.gz
Try it this way :
/usr/bin/mysqldump --all-databases -u roo
I see one conflict that could be causing your "lost connection" message -
you are specifying a 1 GB "max_allowed_packet" for the client, but the
server is configured to only support 64 MB.
You should adjust the "max_allowed_packet = 64M" setting on the server to
match or exceed what you specify on
Unfortunately the additional parameters didn't solve my problem. But
thanks for your response!
ssh [EMAIL PROTECTED] \
"mysqldump -u XYZ --verbose --password=XYZ --quick
--single-transaction --net_buffer_length=1G --max_allowed_packet=1G
dbmail | /bin/gzip" \
> /Backup/HD-Save/
Hiya,
I was backing up a 95GB InnoDB database and forever had problems. It ended up
working and I never really worked out exactly what the cause was... but try
using the following:
--opt (does --quick + extended-insert + others)
--net_buffer_length=1G (set this to whatever you want, 1G is the l
1 - 100 of 595 matches
Mail list logo
