mysqldump : MySQL's Client Backup Utility

learn more… | top users | synonyms

1
vote
1answer
481 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
332 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
1k 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
162 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
719 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
464 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
967 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
794 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 ...
5
votes
2answers
13k 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
169 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
947 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
22 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 ...
0
votes
1answer
3k 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
2k 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
707 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
242 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
370 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
277 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
165 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
472 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
6k 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
11k 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
321 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
261 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
784 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
256 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
1answer
203 views

Better alternative to mysqldump

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
465 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
204 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
490 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
942 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
185 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
1k 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
92 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
11k 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
158 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)
0
votes
0answers
82 views

Create a Mysqldump

I have created a dump of a table but it dumped only a few records instead of dumping all records of the table. Please assist.
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
102 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 ...
1
vote
2answers
881 views

Unknown command error while restoring database from MySQL dump

I am using MySQL 5.1.36. While importing form a MySQL dump I am getting the following error. The 'max_allowed_packet' size is set to 100M in the my.cnf. ERROR at line 1647: Unknown command '\''. Can ...
0
votes
1answer
115 views

Mysql start and backup all tables with SHH Accsess

i have crashed my server.Now is in recovery mode. I have backuped all files but i can't backup mysql tables. From my hosting provider say that i must to start a mysql server and to backup all files. ...
0
votes
1answer
116 views

mysql clustering

i am very new to mysql clustering.Can anybody explain me how to take backup on mysql clustering and how restore mysql clustering backup
0
votes
3answers
257 views

Cronjob to Backup Database every day at 10pm

I managed to setup a cronjob: * 13 * * * date=`date +\%d-\%m-\%Y-\%s`; mysqldump -u root -pPassword1 db121 > /home/backup/xbackup_$date.sql; gzip /home/backup/xbackup_$date.sql I am hoping the ...
3
votes
2answers
1k views

Using mysqldump from 5.1 package to backup data from 5.0 server?

I've ran into problems trying to backup data from table City in world database from mysql 5.0 server on local network: mysqldump --tab=/home/developer/Desktop -u developer -h 192.168.10.196 -p world ...