Tagged Questions
1
vote
2answers
60 views
Restoring a database backup to a local machine in MySQL
I have downloaded my .sql file of my database server. It is in the D: drive of my Windows machine.
I want to restore the back up in my this machine. I used:
mysql database -u root < ...
1
vote
1answer
25 views
MySQL: parallel restores at same time from backup files?
Slightly related to this question, but for MySQL: Would it be possible/wise to execute 2 parallel restores from a single backup?
Is it possible/wise to do a parallel restore of two independent ...
1
vote
1answer
125 views
MySQL Point in Time Recovery For Just a Single Schema?
Is it possible to simply restore a single schema and bring it to a point in time (Say three hours ago) without bringing the entire database back?
I can think of a lengthy method of backing up each ...
2
votes
1answer
189 views
Restore InnoDB tables / database using only data files
I have MySQL Server 5.1.51 installed on Windows Server 2003 as Operating System and using InnoDB as database engine.
I have run DROP DATABASE dbName statement by mistake. I have no backup of that ...
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
1answer
180 views
Slow backup and extremely slow restores
I don't normally work with MySQL but with MS-SQL and am having issues restoring a dump backup of a 9 GB database. I converted it to MS-SQL and it takes a grand total of 4 minutes to restore but the ...
2
votes
2answers
160 views
Why restoring a large sql file via SSH seems to quit partially through the process
I have a large (~5GB) .sql file I am attempting to restore via SSH, it seems to quit in the middle of the restore process.
When I come back hours later after issuing the command (the file has 7 ...
1
vote
1answer
376 views
Error When Restoring Backed Up Tables
I followed directions from this page: http://serverfault.com/questions/271367/importing-data-from-myd-back-up-file
I dropped the 3 files ( t2010_08.frm, t2010_08.myd, t2010_08.myi ) into my ...
1
vote
1answer
141 views
Failed to restore mysql database with zmanda
I want to setup a slave from my backup version of mysql using zmanda (it's a full backup).
I've followed this guide.
Result of mysql-zrm-reporter
backup_set backup_date ...
0
votes
1answer
188 views
Is it possible to resume an interupted mysql import from a backup file?
I created a backup file of my database with phpMyAdmin and checked the following data dump option:
include column names in every INSERT statement
Example: INSERT INTO tbl_name ...
3
votes
1answer
831 views
How large will a MySQL database be relative to the dump file?
I'm restoring a ~52GB dump to a MySQL database. The ibdata1 file has already exceeded the size of the dump file and the restore is still incomplete. Is there any way to estimate the final size of the ...
1
vote
2answers
343 views
Using an older MySQL binlog filename (with position zero)? Risks? Downsides?
Let's say I'm setting up a new slave. I start with a mysqldump after running mysql -e "STOP SLAVE", transfer that and restore it to the new server.
If I didn't capture the BINLOG filename and ...
1
vote
1answer
2k views
Problem with View When Restoring a MySQL Backup
I have a database (InnoDB) with some tables, views and routines...
Periodically I do a backup using the command line:
mysqldump -u user -ppassword --routines db_name > backup.sql
But I have a ...
1
vote
1answer
204 views
GUID as reason for MySQL import slowness
We faced MySQL restores DB VERY slow: ~3 min for 15 MB dump. This is a new dedicated server with a lot of RAM.
We were told the most possible reason is GUID is uded as primary key in many tables:
...
3
votes
2answers
205 views
Getting recovered db files to work on rebuilt server
I've had to rebuild my server and have tried to copy the database files from the old drive to /var/lib/mysql/. I have restarted apache and run 'show databases', this list all the databases. I have ...
2
votes
2answers
234 views
Need help in restore some rows into mySQL database frm myd myi
I am using one mySQL database for several sections of the website and one of the section is not working, when I go to the link of that section it gives the error "1146 Error @ Line 39: Table ...
1
vote
1answer
320 views
Why is Mysqlcheck on 5.1.41 still showing as Innodb table corrupted after a table dump and restore?
I had a very large corrupt innodb table. mysqld would crash whenever I did a check table on it. I did a innodb-force-recovery=1 and did a dump of the table. No errors showed up.
I dropped the table ...
2
votes
3answers
859 views
How do you restore a particular table in MySQL?
One of our users has deleted a table by mistake. How can I restore only that table?
