-1
votes
1answer
126 views

Backup/Recovery like barman for MySQL [closed]

I'd like to have a Backup/Recovery tool for MySQL (MariaDB/Percona) servers which has somehow the same features as barman has for postgresql take full backups on a regular basis (xtrabackup, but ...
0
votes
0answers
194 views

Mysql won't start after replacing data in datadir.

so I have a little problem. I had errors with our old system and was unable to backup the old databases properly so I went ahead and backed up the datadir which had all of the databases folders inside ...
1
vote
1answer
61 views

Restoring mysql dumps from incrementals

This is probably bordering on a silly question, but if I recently restored a Full mysql DB dump via cat dump.mysql |mysql dbname to a new instance of mysql in order to migrate; and I want to restore ...
0
votes
1answer
574 views

Restore mysql databases that is created using direct admin

PS: I'm sorry my description is a bit long. I am just trying to give all the information. At first, I was not able to login to direct admin. I research on the web on what are the causes and found out ...
2
votes
3answers
4k views

Recover MySQL tables from frm files

I'm desperate, and hoping some kind soul can rescue me! I'm dealing with restoring a completely crashed server. Everything is back up except for there's an issue with one domain which uses MySQL (no ...
1
vote
3answers
533 views

Restore MySQL Databases from File backups, not MySQL Export

I've got a Windows Server and I get Windows Server Backup to backup all the files every day. I don't however have a system image so I cannot use that. I've tried just copying the database files into ...
3
votes
1answer
911 views

MySQL: How to backup and restore using different schema name using xtrabackup

I very often need to create a backup of a database and import it using a different schema name. These schema's are pretty large (3-5GB) and mysqldump is a pain. xtrabackup seems promising but I cannot ...
1
vote
2answers
80 views

Is there any option to restore data after deleting from a MySQL table

There are some rows in a table, by mistakenly I had deleted all rows from the table and data got commited. So is there any way to restore data for that table. I am not having backup of the database. ...
-1
votes
2answers
502 views

MySQL table “doesn't exist” error

I'm using Windows 7 Ultimate x64. After reinstalling OS copied back whole MySQL data directory to C:/Programdata. But now when i'm trying to open some table from restored db's with Navicat it shows me ...
0
votes
1answer
635 views

MySQL “max_allowed_packet” error — how do you profile the max packet size?

Keep running into into the "max_allowed_packet" error msg, which to data I've just guessed at what the number should be.... I'd like to stop guessing, and know how to see what the number should be -- ...
0
votes
1answer
490 views

How to recover MySQL database from .mysql file?

We had some problems with our MySQL server and somehow all I've got is a database.mysql file for the database I want to restore. I've done a bit of googleing but I didn't find anything about how ...
1
vote
2answers
530 views

how to restore a mysql dump FOLDER

After having a vps crash, I asked my hosting to give me the dumped file of my drupal database. It is a folder filled with of *.frm *.MYD files of the database tables. I used to restore mydb.sql files ...
0
votes
1answer
205 views

Rebuilding a MySQL database from 160 retreived files with no name

I had a server crash and it took with it the hard drive. I put the hard drive in a USB enclosure, but the main partition would not mount because the partition was corrupted. I was able to see the USB ...
1
vote
4answers
4k views

how to: rescue Data from MySQL (only files on HDD left)

After eventually managing to upgrade my debian virtual server from etch to lenny. (Read here for the full story: http://serverfault.com/questions/168808/debian-upgrade-from-etch-to-lenny-fails) I now ...
0
votes
1answer
479 views

Populate a remote databse using MySQL Workbench and remote .sql file

I'm using MySQL Workbench 5.2 CE, and I try to figure out how to populate or restore a mysql_dump.sql file uploaded to the root of my domain (./mysql_dump.sql). Since the file is a little bit ...
13
votes
5answers
8k views

How can I speed up a MySQL restore from a dump file?

I am restoring a 30GB database from a mysqldump file to an empty database on a new server. When running the SQL from the dump file, the restore starts very quickly and then starts to get slower and ...
1
vote
3answers
333 views

Backup and restore MySQL database without system access

I am trying to move a database from 1 provider to another, the problem is that I don't have system access at either end (ie, no ssh), so I cannot use a mysqldump. I have already tried using MySQL ...
1
vote
3answers
153 views

How to backup MySQL database?

Is there a way to backup an MySQL database so that if something wrong occurs, it will be easy to recreate the tables with the same data?
1
vote
1answer
68 views

Find or restore wiki pages. (Computer will not boot anymore and need the wiki pages)

A few years ago, where I work, I created a wiki for me and my co-workers. We work on a lot of old programs and to help with cross training, we put a lot of our notes in the wiki. Sadly, the wiki was ...
0
votes
2answers
90 views

Am I backing up my database correctly? And then load it as INNODB?

mysqldump -hlocalhost -uUSERNAME -pPASSWORD THEDATABASE | gzip > /home/db_backup/abc.sql.gz tar -xzvf ./abc.sql.gz mysql THEDATABASE -uroot -pPASSWORD < abc.sql The important note is that ...
4
votes
3answers
7k views

How can i backup a table structure but NOT his data in MySQL

I am using MySQL Administrator for making my database backup. I can perfectly backup the whole database with all its tables. There are some tables whose size is very big so i wonder if i could only ...
0
votes
2answers
349 views

MySQL dump-restore replaces characters with 3Fh

FreeBSD Server with Mysql and make.conf like that .if ${.CURDIR} == ${PORTSDIR}/databases/mysql50-server WITH_CHARSET=cp1251 WITH_COLLATION=cp1251_bin BUILD_OPTIMIZED=yes BUILD_STATIC=yes .endif .if ...