mysqldump : MySQL's Standard Dump/Backup Utility
1
vote
1answer
293 views
How mysqldump replaces special characters during dumping records?
i am trying to dump a particular row using java.
So that i retrieve the data by using record sets and i manually written sql script code by appending the dynamic records.
But my problem is i could ...
1
vote
3answers
471 views
“Too many connections” when running MySQLDump
MySQL 5.5.x on Windows, 4GB RAM.
I have a Wordpress Multi-Site install. The WPMU db contains over 6k tables (I know, horrendous... WPMU is not my favorite app right now)
I am running mysqldump ...
1
vote
1answer
202 views
Good strategy to replicate MySQL data
I'm working on MySQL database, well i have a master instance and slaves, and i need to add a new slave to Master. I adopt a simple strategy to do so: Stop slave, import data to new slave, and finally ...
1
vote
1answer
628 views
MySQL - MySqlDump uses \n instead of null
Using Windows with MySQL 5.1.
I am running a script that uses mysqldump to backup a database.
The mysqldump syntax used is:
mysqldump --user=root --port=3306 --password=topsecret some_database ...
1
vote
1answer
1k views
ERROR 1114 (HY000) at line 6308 in file & The table user_analysis is full
There is a SAN mounted 1TB partition for Mysql backups in our server with version 5.0.45-log. From two days, im seeing the log entries ERROR 1114 (HY000) at line 6308 in file & The table ...
1
vote
1answer
98 views
Compare two MySQL dump files
I am trying to compare two MySQL dump files. One was made from a fresh install of a web application and the other is a dump from the same web application that has been upgraded from a previous version ...
1
vote
2answers
94 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 ...
1
vote
2answers
105 views
MySQL: optimal configs / methods for ALTER of large MyISAM table to InnoDB (17gb+)
I have a large MySQL (5.1) MyISAM table (13gb table, 4GB indexes - 40mm+ records)
I'm going to be converting this table to InnoDB in a production environment.
The DB is on a cloud server with ...
1
vote
1answer
95 views
Dump of a mysql table on import replaced existing records
I took a dump using mysqldump..
mysqldump -u... -p... mydb t1 > mydb_table.sql
Then I imported the dump in another database having same table, but different records..
mysql -u...-p... mydb < ...
1
vote
1answer
1k views
mysqldump: Error: 'Can't create/write to file
Can't create temporary files on /var/tmp.
mysqldump: Error: 'Can't create/write to file '/var/tmp/mysql.k6NKGk/#sql_5dc_2.MAI' (Errcode: 2)' when trying to dump tablespaces
On my OS.
id mysql
...
1
vote
0answers
72 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 ...
1
vote
1answer
688 views
Repair with keycache in mysql runs EVERY time. Can't even log why it's happening
I have a MyISAM table w/ ~1million rows and two indexes - one's a three-column key, and the other is a spatial index for bounded SELECT statements on a separate point column. My insert statements ...
1
vote
1answer
269 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 ...
1
vote
1answer
717 views
importing myisam 5.0 database into a 5.5 innodb server
I have MySQL 5.0 and 5.5 servers (but not a 5.1 server). The 5.0 server is myisam only, the 5.5 default is innodb. I need to move a database from the 5.0 server to the 5.5 server. The database is ...
1
vote
1answer
873 views
Write lock during mysqldump even using --lock-tables=false
When I try to dump an online database using --lock-tables=false, others cannot update the table. Are there any methods to solve this?
As I am using MyISAM, does --single-transaction for InnoDB help?
...
1
vote
3answers
55 views
Issue on mysqldump in MySQL5.6
I did upgrade the MySQL server from 5.5 to 5.6
I am trying to take dump for a table like this
mysqldump -uroot -p dba admin > D:\admin.sql
But it gets following error
mysqldump: Couldn't ...
0
votes
2answers
72 views
How to take a database dump for selective set of values in few tables?
create table foo (id, val1, user_id,...)
create table bar (id, foo_id, val2, ...)
create table baz (id, bar_id, val3, ...)
select * from foo where user_id = 1;
select * from bar where id in (select ...
0
votes
1answer
595 views
mysqldump not escaping single quotes properly
I use mysqldump to backup my mysql database.
The problem is that the sql file generated by mysqldump doesn't escapes single quotes properly.
Here is an example of the mysqldump generated sql script :
...
0
votes
1answer
161 views
How to copy MySQL Database from Linux to Windows?
I would like to copy a MySQL database form Linux to Windows, from a little research I found this url http://www.cyberciti.biz/tips/howto-copy-mysql-database-remote-server.html where the author says we ...
0
votes
1answer
54 views
mysqldump not generating USE statement
I've got a small script which allows me to select a database, and a number of tables, then output them via mysqldump.
Currently this does not include the USE 'db_name' statement in the output file, ...
0
votes
1answer
24 views
passing --single-transaction in mysqldump command line tool
I'm using MySQL GUI tool to backup my innodb database and I use the option '--single-transaction' to get a consistent copy as backup.
I have however, noticed that if I backup using command line ...
0
votes
1answer
77 views
mysqldump: Got error: 1017: Can't find file: 'drupal_install_test' (errno: 2) when using LOCK TABLES
I'm trying to backup a drupal site database but I'm having some issues. When I ran the following command:
mysqldump -uroot -p drupaSite > drupaSite.sql
I get the following error:
mysqldump: Got ...
0
votes
1answer
45 views
ERROR 1034 (HY000) : Wrong aligned block, while importing in mysql
I got a SQLdump from my database and now I want to import it in to an other mysql server with same version(5.5.22-0ubuntu1) in ubuntu 12.04 .but at the middle of importing, it said:
ERROR 1034 ...
0
votes
1answer
121 views
importing MySQL dump to SQL Server 2012
I have a database schema from MySQL which I want to import to SQL SERVER, I have tried dumping from MySQL with compatibility for SQL Server, but with no success. Tried dumping as Excel still no dice. ...
0
votes
2answers
79 views
How do I fix the definer problem The user specified as a definer ('fred'@'192.168.0.%') does not exist
I dumped an existing database from my web site into a new MySQL setup on my laptop. Everything works except pages that use a view, when the error message above appears. There is only one view on the ...
0
votes
1answer
142 views
how to dump a single stored procedure from a database
I need to create a dump file that contains a single stored procedure from a database. Not all routines from that database
0
votes
1answer
74 views
Translating backup size to database size
I have a client who gave me a 4 gig datafile from mysqldump that I need to restore somewhere.
Is there a good rule of thumb for translating the size of a backup into the size of the database once it ...
0
votes
1answer
96 views
mysqldump, preserve update_time and modify_time attributes as listed by show table status from
Does mysqldump preserve the create_time and update_time attributes that are output by show table status from?
If not, is there an option that does this?
From the manual it looks like mysqldump ...
0
votes
1answer
71 views
Incomplete MYSQL Dumps
I am using MySQL dump to back up my MySQL Databases and I'm having trouble with a couple dumps on one box.
Server Specs
Windows 2008
MySQL 5.1.48-community
I've tried various ...
0
votes
1answer
71 views
Mysql dump restore doing some funny stuff
I am using linux platform. I also dump the data into a file and I restore into a server and I ran this command
[root@localhost /]# mysqldump -u root -p fms < /device.sql
The funny part it keep ...
0
votes
1answer
251 views
Mysql:Need to upload data to database, get duplicate key error - how can dup keys be ignored
I'm uploading data to a db (mysql 5.1.42) from a dump file using mysql command line and get duplicate key error.
This is the format I use:
/mnt/temp# mysql -u username -p -h url_of_db_master -D ...
0
votes
1answer
25 views
Unable to use mysql_upgrade:
I updated mysql recently and found problem related to privileges and backup. When I am using mysql_upgrade command it says-
mysqlcheck: Got error: 1064: You have an error in your SQL syntax; check ...
0
votes
0answers
20 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
1answer
32 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
2answers
123 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 ...
0
votes
2answers
205 views
How to restore mysql dump file? [closed]
We have created a dump file (.sql) using the command mysqldump in mysql5.5.
Now we want to restore the same. We are using the command :-
-u[username] -p[pwd] [dbname] < [.sql file]
But we are not ...
0
votes
0answers
37 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
1answer
58 views
mysqldump including deleted rows [closed]
I'm trying to move a database from a Windows2003Server with mysql 5.0.27-community-nt to a new server with CenTOS. When using mysqldump on the database on the windows server, one table (i haven't ...
0
votes
1answer
144 views
Problem with (not) Locking Tables during Restore
First time here in DBA. I'm working to create a simple and strong database backup plan. My solution that is already working to create a gzipped, encrypted backup is:
$string = "mysqldump -u$db_user ...
0
votes
1answer
139 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
161 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
45 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 ...
0
votes
2answers
275 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 ...
0
votes
1answer
129 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 ...
0
votes
4answers
506 views
How to do a mysqldump with a use database in the dump
So the command I normally use to get a database sent to another server is:
mysqldump -u user -p --add-drop-tables database *file*
But I always have to go into the file and add a line at the top:
use ...
