mysqldump : MySQL's Standard Dump/Backup Utility
1
vote
2answers
119 views
Mysqldump tables excluding some fields
Is there a way to mysqldump a table without some fields?
Let me explain:
I have a MySQL database called tests. In tests I have 3 tables: USER, TOTO and TATA. I just want to mysqldump some fields of ...
0
votes
2answers
21 views
Error while restoring a Database from an SQL dump
I am extremely new to MySQL and am running it on Windows. I am trying to restore a Database from a dumpfile in MySQL, but I get the following error:
$ >mysql -u root -p -h localhost -D database ...
0
votes
2answers
384 views
How to increase fast backup and restore of 500GB database using mysqldump?
There is a database A size of 500GB. Tables in database A contains both MyISAM and INNODB tables. MyISAM tables are master tables and Innodb tables are main transaction tables.
Backup and restore ...
2
votes
1answer
27 views
Table optimize command crashed MySQL server
I have a large 5GB table on one of my MySQL databases that I wanted to optimize.
I went into the console and ran the optimize command and since it's an InnoDB database it cloned the table to a ...
2
votes
1answer
109 views
Backing up a 400-500 GB database on MySQL/Amazon RDS?
We have an Amazon RDS small instance for a MySQL datawarehousing database.
Database size will be around 400-500 GB very shortly.
What is the best way to backup our database?
Can it be done ...
1
vote
1answer
25 views
mysqldump freezing on a specific table
I dumped a database (sys_data) which is very big (800GB, all data in one ibdata file) from a remote server. But the dump was blocked at a table (tb_trade_376).
My dump command:
mysqldump -uxx -pxx ...
1
vote
1answer
147 views
MySQL backup InnoDB
I have a VoIP server running 24x7. At low peak hour at lease 150+ users are connected. My server has MySQL running with InnoDB engine on Windows 2008 platform. I like to take at least 2 times full ...
1
vote
1answer
277 views
How to prevent high memory, CPU and time consumption by MySQL restore?
I have a local test machine with 2 GB RAM and a dual core processor.
I imported a dump on that using
mysql -uuser -psecret < script.sql
script.sql is a 700 MB file which contains a single ...
0
votes
1answer
25 views
Speeding up mysqldump / reload
Converting a large schema to file-per-table and I will be performing a mysqldump/reload with --all-databases. I have edited the my.cnf and changed "innod_flush_log_at_trx_commit=2" to speed up the ...
0
votes
1answer
45 views
Database user specified as a definer
I have a view in my database. problem is below
Error
SQL query:
SELECT *
FROM `lumiin_crm_prod`.`v_contact`
LIMIT 1 ;
MySQL said:
1449 - The user specified as a definer ('lumicrm'@'%') ...
0
votes
1answer
194 views
Proper procedure for migrating a MySQL database to another Debian machine?
I have one server running an older Debian version with MySQL 5.x and a newer Debian server, also running MySQL.
I've created a backup of all databases on the first server like so:
mysqldump -uuser ...
0
votes
1answer
144 views
mysql duplicate entry error 1062 when restoring backup
Sorry, I seen similar threads but I still couldn't find it addressing my issue plus, I needed some more info on this.
Requirement: To create an exact replica 'db4' of an existing DB 'db3'.
Procedure ...
1
vote
0answers
14 views
how to verify mysql backup file
Is There any tool to verify the backup taken using mysqldump without manual restoration ?
I have to take full backup daily so it is difficult for me to verify the backups daily by restoring them. As ...
1
vote
0answers
74 views
MySQL replication backup
How to take MySQL Master-Master and Master-Slave replication backup?. I have setup Master-Master replication with a separate slave for each master on Ubuntu.
What happens if,
I issue or schedule ...
0
votes
0answers
9 views
Make mysqldump create hex-blob output for polygon data
I want to create a database dump with mysqldump where all binary data output is in hex format. I have some tables containing blob data and those tables are dumped into the nice hex format when I use ...
0
votes
0answers
24 views
'Offline' MySQL backup - server not starting
The MySQL server is no longer starting because the partition is too full. The issue seems to be ibdata (40GB). I wanted to follow these instructions (at 'InnoDB Infrastructure Cleanup')
Now I already ...
0
votes
0answers
39 views
Phpmy admin not showing my table but mysqldump
I have a db running and suddenly when I go into my phpmyadmin under the db it shows no tables and when I tried to do dump it shows me some of my tables are crash. What is best survival in this case?
0
votes
0answers
185 views
MySQL Dump configuration file
I modified th my.cnf file, so that the innodb_data_file_path points somewhere else from the default path. But the mysqldump command seems like trying to dump from the default path.
I found that if i ...
0
votes
0answers
47 views
Best way to merge a Sharded MySQL
I have a MySQL database that is shared across 16 different database servers, and i also have 1 replica for each machine. To save money as product becomes less popular I am wanting to shard down into a ...
