Mysqldump ????

[grantw]

This is driving me mad. I'm trying to individually dump 2 mysql databases using mysqldump but it is not working. The databases are about 30 meg in size, this is what one of the .sql dump file looks like:

-- MySQL dump 10.9
--
-- Host: localhost Database: db_name
-- ------------------------------------------------------
-- Server version 4.1.22-standard

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;

That's it, no tables or data are being dumped.

I've tried the command line and a php script, same result. This is my php file:

<?php

$command="mysqldump --host=localhost --user=username --password=password database_name > dump.sql";
system($command);

?>

Any ideas why it's not working or does anyone know of an alternative to the mysqldump command?

Cheers, Grant

 

[accelerator]

I use MySQL Administrator to create backups of databases.

Rgds

 

[jimm]

Has this worked ever?
What version of mysqldump have you got?
There was a version which did this i seem to remember.

 

[grantw]

Has this worked ever?
What version of mysqldump have you got?
There was a version which did this i seem to remember.

I've never used it before so unsure. How do I check the version please?

Thanks, Grant

 

[aquanuke]

Have you tried through a shell, might be php timing out or limits.

 

[grantw]

I use MySQL Administrator to create backups of databases.

Rgds

Tried this and get this when i try and run it

"Gtk-WARNING ***: cannot open display"

So given up on it..............

Cheers, Grant

 

[grantw]

Have you tried through a shell, might be php timing out or limits.

Yep, have been using the command line most of the time. Driving me insane.

Grant

 

[grantw]

OK, should have tried this a while ago! I've just dumped a very small database and that worked fine so I'm guessing this is related to the size of the database.

Any ideas?

Thanks, Grant

 

[aquanuke]

How about phpmyadmin

http://www.phpmyadmin.net/home_page/index.php

 

[retired_member21]

For an alternative GUI - you can always try Navicat. It has a .php you can upload file for http tunnelling in should 3306 not be open on server

 

[grantw]

How about phpmyadmin

http://www.phpmyadmin.net/home_page/index.php

It's on there already but the cpanel licence has expired. I got a trial license this morning but the license update on the server keeps failing which I think is due to the ip address recently changing. I changed the A record on the domain earlier to the new ip address so it will probably be easier to wait for that to resolve correctly and then update the license.

Thanks, Grant