or u can use "for loop", have only the database to be exported and use that
variable in --database and do mysqldump of each database.
On Thu, Sep 15, 2011 at 6:27 PM, Carsten Pedersen wrote:
> On 15-09-2011 10:31, Chris Tate-Davies wrote:
>
>> Adarsh,
>>
>> 1)
>>
>> When restoring a mysqldump you
On 15-09-2011 10:31, Chris Tate-Davies wrote:
Adarsh,
1)
When restoring a mysqldump you have the option of which database to
restore.
mysql database1 < backup.sql
Admittedly, it's been a few years since I last used mysqldump, but I
suspect that it will contain USE commands - as such, it wil
Adarsh,
1)
When restoring a mysqldump you have the option of which database to restore.
mysql database1 < backup.sql
2)
You might be able to use the --ignore-table command. I'm not sure if
this would work
mysqldump --all-databases -q --single-transaction
--ignore-table=databasetoignore.*
Dear all,
Today i backup my all databases (25) by using the below command :-
mysqldump --all-databases -q --single-transaction | gzip >
/media/disk-1/Server11_MysqlBackup_15September2011/mysql_15sep2011backup.sql.gz
Now I have some doubts or problems that I need to handle in future :
1. Is
Hi,
Take the dump using --tab which will give you .txt and .sql file.
Move the dump to the new version of mysql and try using load data infile
'/tmp/user.txt' into table user;
Jørn Dahl-Stamnes wrote:
On Thursday 22 June 2006 04:00, Daniel da Veiga wrote:
On 6/21/06, Jørn Dahl-Stamnes <
On Thursday 22 June 2006 04:00, Daniel da Veiga wrote:
> On 6/21/06, Jørn Dahl-Stamnes <[EMAIL PROTECTED]> wrote:
> > On Wednesday 21 June 2006 17:17, Barry wrote:
> > > Jørn Dahl-Stamnes schrieb:
> > > > Is it possible to get mysqldump to include rights that has been
> > > > GRANTED to a database
On 6/21/06, Jørn Dahl-Stamnes <[EMAIL PROTECTED]> wrote:
On Wednesday 21 June 2006 17:17, Barry wrote:
> Jørn Dahl-Stamnes schrieb:
> > Is it possible to get mysqldump to include rights that has been GRANTED
> > to a database or to tables in the database that is being dumped?
>
> Dump the Grant t
On Wednesday 21 June 2006 17:17, Barry wrote:
> Jørn Dahl-Stamnes schrieb:
> > Is it possible to get mysqldump to include rights that has been GRANTED
> > to a database or to tables in the database that is being dumped?
>
> Dump the Grant tables?
I have though of it. Currently I am dumping the mys
Jørn Dahl-Stamnes schrieb:
Is it possible to get mysqldump to include rights that has been GRANTED to a
database or to tables in the database that is being dumped?
Dump the Grant tables?
--
Smileys rule (cX.x)C --o(^_^o)
Dance for me! ^(^_^)o (o^_^)o o(^_^)^ o(^_^o)
--
MySQL General Mailing
Is it possible to get mysqldump to include rights that has been GRANTED to a
database or to tables in the database that is being dumped?
--
Jørn Dahl-Stamnes
homepage: http://www.dahl-stamnes.net/dahls/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe
ged into your audience
-Original Message-
From: Li Yang [mailto:[EMAIL PROTECTED]
Sent: Sunday, March 30, 2003 8:10 PM
To: mysql
Subject: Hi,All ,About mysqldump and mysqlimport
Hi, I'm a newbie to MySQL
I have use mysqldump to backup a database to an file named test.sql
,but h
Hi, I'm a newbie to MySQL
I have use mysqldump to backup a database to an file named test.sql ,but how I
can load the test.sql to create the same database to another server??
Thanks!
Best Regards
Li Yang
Hi,
I want to know, whether the recovery from the file created using
mysqldump,
will also recover the foreign key between the tables.
because when I am doing this it doesn't seems like that..
when I am doing recovery I am loosing all the foreign keys of by
database tables.
please, tell me it is a
13 matches
Mail list logo