0
votes
1answer
31 views

Database replication with old data

I am using MySQL to accomplish Database replication. The replication process is works very well. What my problem is, the old record is not copied from the master database. Is there is any way to keep ...
0
votes
1answer
148 views

Is it possible to dump a postgresql db and restore it in mysql?

I'm trying to get migrate data from a postgre db into mysql (mariaDB) and was wondering if it is possible to restore a db in mysql from a pgsql dump?
1
vote
1answer
230 views

Create dump of database schema remotely

I have a connection to remote Mysql database. (i'm using MySQL Workbench). I'd like to copy whole structure of the database, (without data) to create identical structure on my local machine. Is it ...
1
vote
2answers
721 views

Cherry pick and import tables from remote mysql database into local?

I have a local mysql database called intranet_production, and on a remote server (which I have root access to the server and mysql) there is a database called 'extranet`. Within the remote extranet ...
1
vote
4answers
617 views

How to load large SQL file into mysql

I have a database backup of a MySQL database that is about 250MB. I made it with mysqldump I was trying to load it on another server like so: mysql -u xxxx -pxxxx data_mirror < dbdump.sql I was ...
0
votes
1answer
928 views

Restoring MySQL dump - ERROR 2006 (HY000)

I am just trying to restore a mysql dump. Below are the command and error message. Can anybody give me some clues how to approach this? 10:54:16 Restoring ...
2
votes
1answer
166 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
103 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 ...
0
votes
2answers
400 views

Mysqldump confusion?

If i will lock my tables while taking dump of production and at the same time if user will enter any data for specific table. What will happen to that specific insertion ? Will it be discarded or it ...
1
vote
4answers
1k views

mysqldump with single transaction option on live production servers

I am currently investigating a mysql backup solution to implement on some production servers. After reading a while, I concluded that the best solution is to implement a mysql replication using the ...
6
votes
2answers
4k views

mysqldump error LOCK TABLES

When I execute a mysqldump I get following error: mysqldump -u root -ppassword --databases information_schema > test.sql mysqldump: Got error: 1044: Access denied for user 'root'@'localhost' to ...
0
votes
2answers
2k views

MySQL Tables Missing/Corrupt After Recreation

Yesterday I dumped my MySQL databases to an SQL file and renamed the ibdata1 file. I then recreated it and imported the SQL file and moved the new ibdata1 file to my MySQL data directory, deleting the ...
3
votes
4answers
2k views

mysqldump --where with = operator doesn't get all rows

I have a situation with a particular table that now thinks it contains 4 Petabytes of data. I know that sounds cool, but I assure you, it is only on a 60GB partition. This table has 9 fields in it. ...
1
vote
2answers
369 views

How to restore just ONE mysql database from a collective backup

I have a scheduled mysqldump task that uses the --all-databases option. This includes all databases in one file. How can I tell mysql to import ONE of the databases contained in the dump file? -M ...
2
votes
3answers
2k views

MYSQL backup and restore

I am having trouble getting mysql backups to run properly when their are views in the database. I think this might have something to do with needing a placeholder object for it. In any event I run ...
4
votes
10answers
3k views

how to complete mysql daily backup dump without timeouts?

what is best way to complete daily Mysql database backup, we are having critical mysql database connection timeouts during backup dump we use dump and gzip cron has a line: 1 1 * * * root nice ...
1
vote
1answer
2k views

mysqldump for UNIX domain socket

I have setup a new mysql database with my webhosting provider and the hostname is not the default localhost it is localhost:/tmp/mysql5.sock I think this is becuase they are moving from mysql 4 to ...