1
vote
2answers
494 views

mysqldump: unknown option '--:q'

mysqldump worked fine just yesterday. Today I tried to dump a database and got this error message mysqldump: unknown option '--:q' Nothing helps, I checked all the parameters, runned "mysqldump ...
1
vote
5answers
350 views

Mysql large database backup

How can I backup a large database in mysql? Folder size of Database is more than 5GB & contains 1.5 Lakh tables. I have tried to backup server through phpmyadmin but no luck.
2
votes
2answers
335 views

mysqldump is not dumping my data

I am running mysqldump on Ubuntu Linux (10.0.4 LTS) my mySQL version info is: mysql Ver 14.14 Distrib 5.1.41, for debian-linux-gnu (i486) using readline 6.1 I used the following command: mysql -u ...
0
votes
1answer
455 views

Import from *.sql into mysql… IBD files missing

Running ubuntu 10.10, MySQL, I imported a set of databases from a backup. The import looks OK - I can query the databases and see data in them. The strange thing is that in the /var/lib/mysql/ ...
1
vote
5answers
320 views

Do I need to bring my website down just in order to use mysqldump?

I have a LAMP website with mysql backend with InnoDb engine for tables I would like to be able to use mysqldump to take periodic dumps of the database - WITHOUT having to stop the mysql server (i.e. ...
0
votes
2answers
114 views

MySQL data disappearing after restoring from backup

I recently had to move from one hosting provider to another (if you're in the UK don't use Easyspace for your VPS!) as my previous host dumped my server without warning. Fortunately I had remote ...