mysqldump : MySQL's Standard Dump/Backup Utility

learn more… | top users | synonyms

0
votes
1answer
64 views

Copy database from one mysql sever to another mysql server

Following are the details of the database and server: Server1: Host Name: abc Port Num: 01 database: test Server2: Host Name: xyz Port Num 02 database: spareparts userid: spts password: abcdefgh@123 ...
0
votes
3answers
158 views

How to upload 1.5GB sql file on mysql?

Whenever I tried to import file in MySql on my Linux Mint system, "You probably tried to upload a file that is too large. Please refer to documentation for a workaround for this limit." this message ...
0
votes
1answer
43 views

Mysql dump with View dependent on user

I use simple mysqldump with only parameters are login and db details. No option of anykind is set. Now, when I recieve the dump file, it export the view in steps (I am sure you all know it, but just ...
0
votes
1answer
67 views

Exporting Very Large Database from mysql 5.5

Before I proceed, I would like to confirm can I export a very large table of 3.6GB size using the MySQL Admin Export feature. I have exported tables of small size like 28 MB but just wondering ...
0
votes
1answer
52 views

Sync MySQL 4.0 table to MySQL 5.6 server every few minutes

I am tasked with getting a copy of a table on a MySQL 4.0 server synced to a completely different database on a MySQL 5.6 server every few minutes for the purposes of having that table available ...
0
votes
1answer
104 views

want to download 3GB database table from my development mysql server [duplicate]

I need to download database structure with data. Total size of the DB is more than 3GB. If i use phpmyadmin it is not working. I have also tried by increasing the execution time in php.ini. I need ...
0
votes
1answer
40 views

how to speed up cpu limited mysql database backup

I have a database that has a structure that unfortunately requires having a lot of tables (10k+). It's not possible to change the structure now. The database itself is not very large (<1GB), but ...
0
votes
1answer
284 views

Upgrading mysql myisam 5.1 to mysql 5.6: force innodb on restore?

I inherited a DB using myisam on mysql 5.1 because of the need for fulltext search. I now read that fulltext search is available on mysql 5.6 innodb. Doing this would solve a lot of problems, as long ...
0
votes
1answer
215 views

mysqldump dump file size

I have used mysql-administrator to back up my mediawiki and bugzilla database. Now there is an issue with charsets I can't fix. So I deciced to try mysqldump with -single-transaction --routines ...
0
votes
2answers
96 views

synchronizing local and server database

I am developing a billing system software. For this I have created a database it contains many tables database and this is in local system all transactions data will be stored in local systems ...
0
votes
1answer
350 views

Deadlock from mysqldump --single-transaction, is it possible?

Is it possible to get a deadlock if you ran mysqldump with the argument --single-transaction ? or any other complication ? If it is used to backup a live site with many other querys running at the ...
0
votes
1answer
110 views

MySQL data retained after OS reinstall

Something strange happened today. I reinstalled my OS and then when I reinstalled MySQL workbench some of my old data was still there. I think the actual local db is empty, but all the connections, ...
0
votes
1answer
92 views

Optimizing and maintaining test databases for a web development team

Right now when we test, we mysqldump from the production database, load it into the test database server, and then use scripts to scrub sensitive data. As the database is getting bigger, this process ...
0
votes
1answer
370 views

Export just rows modified in last month (date defined by user)

I'm asking if it's possible in MySQL to export just rows modified in a period of time for example in the past month, if it is possible, how?
0
votes
1answer
105 views

How we take dump with batch of records option?

we have 30 GB database.we want to take backup of this database. here the question is we want to take the backup batch of every 10k records. How we can take batch of records backup using mysqldump
0
votes
1answer
584 views

Is there a system wide way to change MariaDB to create tables using ROW_FORMAT = DYNAMIC

I've got a 700MB dump file from a mysql database that I was trying to undump into a new install of MariaDB and I got this error ERROR 1118 (42000) at line 7481: Row size too large (> 8126). ...
0
votes
1answer
1k 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
5k 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
411 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
256 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
361 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
4answers
2k 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 ...
0
votes
1answer
106 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
418 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
0answers
10 views

How I do a complete backup restore of MySQL Schema with views and functions?

I am trying to backup a single schema on a Windows server and restore it to an Ubuntu 12.04 Linux server running MySQL 5.5.4. The schema includes views and functions. When I used the MySQL Workbench ...
0
votes
1answer
64 views

ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

I know this might be a duplicate of some other posts. But those solutions didn't work for me and I've lot of issues within those answers. Neither could I comment nor post in there, I'm posting a ...
0
votes
1answer
53 views

When try to do Mysqldump Backup from console then getting such as error [closed]

mysqldump: Got error: 2003: Can't connect to MySQL server on 'localhost' (10061) when trying to connect when i am tring to do MySQLDump backup from console then getting such as above error. I am ...
0
votes
1answer
36 views

Why MySQL imports only one record for each table?

Code shows some info: $ cat /etc/*-release | grep VERSION 6:VERSION="12.04.5 LTS, Precise Pangolin" $ mysql --version mysql Ver 14.14 Distrib 5.5.40, for debian-linux-gnu (x86_64) using readline ...
0
votes
0answers
48 views

mysqldump: Got error: 1044: Access denied for user 'username'@'localhost' to database 'databasename' when using LOCK TABLES

mysqldump: Got error: 1044: Access denied for user 'username'@'localhost' to database 'databasename' when using LOCK TABLES I am able to loging properly and able to take full backup from SQLyog Tool ...
0
votes
1answer
57 views

MySQL dump - how to order tables?

It seems that mysqldump dumps tables in sequential order - using the same order tables are shown when running: show tables; I would like to reverse that order - is it possible to do without getting ...
0
votes
1answer
29 views

MysqlDump with ignore errors

I'm helping a friend to backup his database, but I can't get it right doing standard mysqldump process, when I try to use mysqlcheck, I sort the result: http://pastie.org/9748430 '___') It's ...
0
votes
1answer
32 views

Mysqldump without slow query

Situation: I currently monitor an instance of MySQL for slow queries. We have a mysql user dedicated to backups which performs a mysqldump, but the mysqldump gets logged as a slow query. Question: ...
0
votes
1answer
51 views

mysql database migration of schemas with updated data and structures

I am a newbie with MySQL database dumps and am currently trying to work with data migration between a source schema and a target schema. Assuming the source schema is defined by ...
0
votes
1answer
88 views

NDB Cluster seems to ignore foreign_key_checks=OFF

According to MySQL documentation on the local foreign_key_checks variable Beginning with MySQL Cluster NDB 7.3.2, setting this variable has the same effect on NDB tables as it does for InnoDB ...
0
votes
1answer
58 views

I noticed that my MySQL slave's DB size is smaller than the Master's DB

I have a very simple setup of a master MySQL DB with one slave MySQL DB replicating from it. Initially, when setting up the slave, I used mysqldump to get an initial DB dump from the master like ...
0
votes
1answer
55 views

Amazon RDS freezes on mysqldump

My questions is quite similar to Mysqldump from the Amazon RDS. I have the same behavior. Everytime when I do a backup using mysqldump my entire RDS freezes and hence my application is not responding. ...
0
votes
1answer
32 views

Myloader command: Table doesn't exist

I took the backup of mysql database using mydumper command: mydumper -B mydb -o /backup/oct3 -s 500000 -c -m -S /tmp/mysql.sock -u root -p password@123 -v 3 Now, I am restoring mysql database ...
0
votes
0answers
37 views

Best upgrade path for MySql 4.1 to 5.5?

Background Our production environment runs on a system that nobody wanted to update for a long period of time. With a new sherrif in town, we're going to update it. Production is MySql 4.1 with ...
0
votes
0answers
493 views

convert SQL file into CSV directly without server

I have a quite big mysqldump file (36G) I know I can use mysql < big_file.sql SELECT * FROM big_table INTO OUTFILE '/tmp/big_table.csv' FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED ...
0
votes
1answer
27 views

Use mysqdump to backup table with a new table name

Is there a way to back up a table using mysqldump so the table that is being backed up can have a new name in the sql script created by mysqldump. So that If I back up the table 'test_table' like so. ...
0
votes
1answer
57 views

Access denied to user ODBC, but trying to login as root

I'm trying to do a backup of a MySQL database on Windows, but for some reason it's trying to log me in as ODBC instead of root - does anyone know why? As you can see below the red line, I can login ...
0
votes
1answer
30 views

I'm building up a large MyISAM table from a few dumps. The first 21GB took less than 10 hrs total. The next 5GB is forecasted to take two months

I had a couple machines building up identical MyISAM tables. I've dumped all of those tables to a few files, and am now trying to restore them all into a single table on my own machine. The first ...
0
votes
0answers
29 views

mysqldump replace option - ubuntu / mediawiki

I know this is probably a silly question, but I'd like to be sure, rather than make assumptions. There's the option to use 'replace' in a mysqldump, which uses the 'REPLACE' rather than the 'INSERT' ...
0
votes
1answer
462 views

mysqldump: Got error: 1066: Not unique table/alias [closed]

What usually causes this mysqldump error? exec error: Error: Command failed: mysqldump: Got error: 1066: Not unique table/alias: 'TableFoo' when doing LOCK TABLES
0
votes
0answers
65 views

How to change the domain name or IP address in mysql database in every tables

I was using Openfire chat server in Ubuntu, whose IP address was 192.168.1.15. Then, I wanted to move it to other ip (192.168.1.55), so i took a backup of my database. The database I was using is ...
0
votes
1answer
739 views

mysql dump a table to remote host

i want to dump a table from localhost host (with public ip), here is the command so far, the command will be run on localhost mysqldump --opt --host localhost --user=username --password=password ...
0
votes
0answers
95 views

Granting file privilage for an user on amazon RDS(MySQL)

I am having an Amazon setup for my application and I use RDS server which runs MySQL server(Not done by me.Company got it done from some freelance admin). I have a root user created in there but it ...
0
votes
0answers
181 views

Updating +150,000 rows using .sql file causes ERROR 2013 Lost connection to MySQL server during query

I am using ubuntu 12.04. I have a .sql file that is around 5 megabytes. When I use the command: mysql -u -p -v database query.sql The server prints out the content of the file (because of --verbose) ...
0
votes
0answers
69 views

MySQLDump and Amazon RDS

I need to dump the contents of an RDS database into a SQL file, and restore that file to another RDS or MySQL instance. On the RDS instance there are a number of databases and users, and I would like ...
0
votes
1answer
98 views

Using mysqldump on RDS to export a large file in TSV format

I would like to export a single, large table (30GB) from an RDS MySQL server on a regular basis into a TSV file, so that we can load the file into Vertica. However, RDS doesn't provide a way to use ...