mysqldump : MySQL's Client Backup Utility

learn more… | top users | synonyms

1
vote
2answers
531 views

Mysql dump restoring

I ran into a big trouble. I made mysql dump using version 5.0.77 without setting the compatibility mode (I wasn't aware of this problem). Actual mysql server is version 4.0.18. Today our database ...
1
vote
2answers
842 views

mysqldump: unknown option '--:q'

mysqldump worked fine just yesterday. Today I tried to dump a database and got this error message mysqldump: unknown option '--:q' Nothing helps, I checked all the parameters, runned "mysqldump ...
2
votes
1answer
393 views

mysqldump doesn't export all records from table

I'm using mysqldump to move the database to another server. Everything works fine, except that mysqldump doesn't export all records from one table. The table contains about 500 records, and ...
0
votes
1answer
173 views

mysqldump asking for password even after telling it the password in the command line option

I am using the following command: mysqldump -alv -h 123.123.123.123 --password=P@ssw0rd --user=UsernameHere --add-drop-table -p DatabaseSchemaName > dump.sql Then it asks me to Enter Password. ...
3
votes
3answers
271 views

Multiple SSH sessions in a single command

I'm trying to copy a database from one server to another. I tried using the following command and it's getting tied up on entering the ssh passwords. If I put in one server's password, it complains ...
1
vote
5answers
480 views

Mysql large database backup

How can I backup a large database in mysql? Folder size of Database is more than 5GB & contains 1.5 Lakh tables. I have tried to backup server through phpmyadmin but no luck.
1
vote
1answer
512 views

Using AutoMySQLBackup on Rackspace Cloud

Since Rackspace Cloud only allows FTP access it makes using AutoMySQLBackup a little trickier, and while it is at least creating DB dumps I get errors in the backup log: ###### WARNING ###### Errors ...
2
votes
1answer
427 views

Store the MySQL client password, or setup password less authentication

I am using the mysql command line client and I do not want to need to provide the password every time I start the client. What are my options?
2
votes
5answers
2k views

Slow Mysql import

I import a database, and when i run mytop i see only one thread running an insert. On a big database of 80G that will take really big time, is there any tools or may be an option to increase number of ...
0
votes
1answer
192 views

How to block the MySQL export option

I searched here and googled for this answer but had no success. I need to block the export option from a user at my MySQL database, is there a way to do it? I already blocked the update and edit ...
1
vote
1answer
874 views

Fail to dump large size sql in phpmyadmin. Where to set PHP Timeout Limit? (CentOS with cPanel)

My server: CentOS 5.x, cPanel/WHM, PHP 5.3.6. I am trying to import a large size of mysql data into a db with phpMyAdmin, the progress is terminated. It says: Below, it also mentions that: So ...
0
votes
3answers
1k views

MySqldump success or failure test

I am using mysqldump to take the backup of my mysql database and have put it under a cron job . I want to test its success or failure and want it to echo the Success or Failure Message in the cron job ...
1
vote
1answer
566 views

Zenoss MySQL database backups are huge after multiversion upgrade

The Context: We ran Zenoss 2.2 for way too long, and decided it was time to upgrade to the current version, 3.2. I followed the upgrade steps here, and checked to make sure everything was working ...
-1
votes
4answers
2k views

Dump all databases with SSH access

I would like to know how to dump all databases into a folder. I'm using a Linux/Debian Afer connecting on the server with root access I make $ mysql -u admin -p To connect on mysql. Then which ...
2
votes
3answers
962 views

What is the best way to move MySQL data from one server to another

I am switching VPS providers and I want to get my MySQL table data in one server over to another. I currently have a daily mysqldump of all the tables and the biggest tables have in excess of 10M rows ...
6
votes
3answers
15k views

What causes the MySQL error 1062 - duplicate entry when starting slave?

MySQL Master version: 5.5.16-1 MySQL Slave version: 5.5.18-1 The master's snapshot is created by: mysql> FLUSH TABLES WITH READ LOCK; shell> mysqldump --all-databases --master-data > ...
2
votes
1answer
185 views

Make mysqldump output USE statements or full table names when dumping a single table with where clause

Is it possible to get mysqldump to output USE statements for a single (partial) table dump? I've already got some scripts that I'd like to reuse which run mysqldump with some arguments and apply ...
3
votes
1answer
3k views

mysqldump > unknown table engine 'PERFORMANCE_SCHEMA'

I can not backup my databases by using myslqdump, here's the message: # Error: Unknown table engine 'PERFORMANCE_SCHEMA', inpossible to LOCK TABLE This error-message doesn't disappear, also after ...
1
vote
1answer
1k views

How to configure mysqldump to avoid max_allowed_packet error

Honestly it baffles me that with a completely default installation of mysql if I run mysqldump with default parameters it generates a SQL file that can't be imported into another completely default ...
0
votes
1answer
23 views

2 databases locked, but only one can be successfully dumped (backed up do *.sql file) … fail

i have this situation 2 large databases on mysql server - srv1 I need to transfer both to new server - srv2 so I use sql command "FLUSH TABLES WITH READ LOCK;" to stop all modifications Then I ...
1
vote
1answer
4k views

Exporting MySQL without trigger data?

I'm using the MySQL Workbench tool to export a database. However, the database data includes trigger data as well. How can I ignore the triggers and not include them in the generated SQL dump file?
4
votes
4answers
3k views

How to create a SQL Server database from a mysqldump file automatically on a daily basis?

Recently, a vendor announced that they were upgrading their processes, and an automated, daily data dump we are getting from them will now come in a MySQL datadump format. Unfortunately, we're a ...
2
votes
2answers
782 views

which is faster mysqldump/restore or alter table?

I have InnoDB databases and they are using the same ibdata file, the size of this ibdata is around 250G. now i have one of those DBs around 100G. My manager asked me to move this DB to another server ...
4
votes
2answers
179 views

Can I mysqldump an entire DB connection?

I am hosted on a Media Temple DV 3.5 server and looking to upgrade from mysql 5.0.90 to the latest mysql so I can use triggers and foreign keys. I am a bit nervous to do so because I don't have a ...
1
vote
1answer
259 views

wamp - My SQL DB import

I reinstalled wamp. Now I want to import the mysql DB on old wamp/../data folder into newly created wamp mysql db. I copied the folder called party from the old wamp/../data to new wamp/../data. Now I ...
-1
votes
1answer
387 views

How do I restore a dump taken with mysqldump?

I took a backup from a Linode VPS using the mysqldump command, but then when I try to restore that dump into my localhost, it shows the dump was successfully imported but actually nothing gets ...
0
votes
1answer
329 views

mysqldump without password prompt - but for different hosts and users

I googled a while but couldn't find an answer. Although it is often explained, how you simply could put a .my.cnf into your /root and make your funny full database dumps without having to enter a ...
1
vote
4answers
206 views

MySQLDump - Is there any way I can enter the password with -p or --password?

I have an Ubuntu server with MySQL. On the command line, this works mysqldump -u root -p paydaydebt (then I have to manually type the password) On the command line, these do not work: ...
0
votes
1answer
521 views

MySql backup using mysqldump in replication environment

I was checking the mysql backup script that being designed by senior mysql admin (left long time ago), just in order to implement the same setup for different client. all the steps were clear and ...
1
vote
3answers
8k views

How do I dump view schemas for a MySQL database?

I have a MySQL database for which I wish to dump schemas for views. How do I do this? I tried mysqldump with --no-data, but that only dumps table schemas.
3
votes
2answers
13k views

How do I ignore errors with mysqldump?

When dumping a database, I'm getting mysqldump: Couldn't execute 'show create table `some_table`': execute command denied to user 'some_user'@'%' for routine 'some_routime' (1370) and then the ...
1
vote
1answer
323 views

will mysqldump lockout select or read only based queries

i have a large database to backup nightly and we currently do mysqldump on the master server which locks all inserts when dumping we use a master slave mysql setup with magento configured to send all ...
2
votes
4answers
370 views

Automatically restoring a dump.sql file to another server weekly

I am currently trying to find a way to automatically restore a dump.sql file to another server weekly. I haven't found the code to do this yet in either mysql or command prompt but I am looking. The ...
6
votes
1answer
866 views

System Upgrade introduced an unusual mysql privilege error

After a box running mysql was upgraded a backup script is returning an error for databases with Innodb tables. A system running Debian 5 (Lenny) has been upgraded to Debian 6 (Squeeze), and the ...
0
votes
2answers
269 views

Restore 200+ mysql databases

I have 200+ mysql database dump in tar.gz format. Restoring all of them one by one is very time consuming. Is there any way so I can restore all these database in a single transaction. Thanks for ...
1
vote
2answers
255 views

Better alternative to mysqldump [closed]

Is there a better (free) alternative to mysqldump? Because lately i'm having problems with corrupted database dumps. Mysqldump creates faulty sql code and when trying to restore the DB it fails with a ...
4
votes
2answers
3k views

MySQL slave replication reset with no Master Downtime (using MyISAM)

Root of the issue: In all instructions for creating a slave on a running master requires flush tables with read lock. We use MyISAM, so we can't just use --single transaction to get consistent table ...
1
vote
2answers
692 views

What is the best way to take backup of live mysql database for MyIsam tables

I don't want to convert the tables to InnoDB what is the best way to take safe backup of my live site? I've gone thru many posts in this site. I think there isn't unless we down the site in case of ...
0
votes
1answer
217 views

MySQL database import generates unusable database dumps

I'm taking backup of my database and it has text field which contains following content: Original data: "Rock'n Roll" Database backup: "Rock\'n Roll" What it should be in backup: "Rock''n Roll" So ...
1
vote
4answers
616 views

Looking for the best way to backup Mysql

What's the most appropriate way to backup Mysql databases? I would like to have the backups in at least 1 hour intervals. I though mysqldump was the only option but It turns out there are other ...
4
votes
5answers
1k views

MySQL, is there a way to tell when was database last changed/modified?

I'm creating MySQL dump of 5 databases every hour. 3 of those databases very rarely change, so creating a MySQL dump for those 3 dbs is pretty much a waste of time and resources. Is there a way I can ...
3
votes
3answers
189 views

Question: MySQL db Migration from Server(A) to Server(B), which tables?

When migrating a MySQL database from Server(A) to Server(B) which tables should be dumped and migrated to Server(B), including user grants? I don't want to have to manually re-enter user accounts and ...
4
votes
2answers
2k views

MySQL export tables with prefix from Unix command line

I want to export certain tables from one database and import them to another. The tables in question are used for my MediaWiki installation and are prefixed with "wiki_". I do not have access to ...
0
votes
1answer
94 views

MySQLDump backup a MySQL containing table of different charset

If a database contains contains table of different charset, what should I do in order to have them appear in a single file? or is it possible?
0
votes
2answers
1k views

importing data from .MYD back up file

How I can load the data from myd back up file to the database table? I have all 3 files: frm , myd and myi.
2
votes
2answers
1k views

How to dump a mysql database and transfer to remote ftp in one line -for crontab-?

I need to do a weekly backup of a mySQL table and then transfer it to a remote machine using ftp. This is the command I have now in crontab: 0 18 * * 1 /usr/bin/mysqldump --add-drop-table ...
10
votes
3answers
13k views

Can't backup the mysql table with mysqldump. SELECT,LOCK TABL command denied for 'cond_instances'

I am having trouble running mysqldump as the mysql root user. When I try to backup the mysql table I get this error: mysqldump: Got error: 1142: SELECT,LOCK TABL command denied to user ...
2
votes
1answer
189 views

Is it safe to backup crashed MySQL table?

The cache table (MyISAM) marked as crashed. Is it safe to backup before repair? (I'm worried if the repair process gone wrong)
1
vote
2answers
1k views

Making a more resilient MySQL backup script

I have a standard mysqlbackup script that runs in cron. We recently had an issue where we removed a column from a table that a view was referencing. As such, our backup script was failing with an ...
1
vote
2answers
107 views

MySQL Replication Server Error

My replication server showing the following error,Please go through the query and tell me your comments.The insert query is working in live DB server Properly , but showing error in replication DB ...