Need a Dump Truck

timstring

More like a 5-gal. bucket.

When I do this inside a terminal shell:

mysqldump -u 'root' -p 'gi...9' --all-databases > all_db_backup.sql

I get a file that is measured in bytes. I've done the same on a different computer and get the same result. I have also tried to create a dump file from inside NaviCat on both machines and also get the same result.

traq

... not sure what your problem is. Do you mean to imply that data is missing from your dump?

timstring

Yes, data is missing from the dump. The file should be several megs.

NogDog

Might also be worthwhile to look at what is actually in the file, too, just in case some interesting STDOUT stuff got redirected there.

dalecosp

Mysqldump dumps plain text, as you probably know, so I second NogDog ... take a look at see if it says anything. Like "your password is inconnect" or something ... perhaps your flavor uses different switches, etc.

The other part, I guess ... from a client, can you verify there is actually data in the database?

And last, doublecheck the filesize of the resulting file with more than one tool ... perhaps "du -hc dumpfile.sql" or similar?

Just some thoughts. 🙂

dalecosp

Also, does it work for just one database (mysqldump -u root -p pass mysql). And does root have LOCK_TABLES privileges ... (should, of course).

Derokorian

For what its worth,

If you use the short option form (-p), you cannot have a space between the option and the password.

--Man

Also note, none of the examples on that page or anywhere I can find use quotes around the username or password.

timstring

I know this is an old problem, but is has bitten me again. When I use dalecosp's

mysqldump -u root -p pass mysql

I get a whole lot of answers that are greek to me. The last line says:

Got error: 1146: Table 'mysql.innodb_index_stats' doesn't exist when using LOCK TABLES

I have re-installed MySQL-5.7.1-m11 twice and the table isn't created.

The calls_to_dispatch.sql file simply reads:

/*
 Navicat Premium Data Transfer

 Source Server         : KathyString
 Source Server Type    : MySQL
 Source Server Version : 50701
 Source Host           : localhost
 Source Database       : calls_to_dispatch

 Target Server Type    : MySQL
 Target Server Version : 50701
 File Encoding         : utf-8

 Date: 07/19/2013 10:46:47 AM
*/

I've found a whole bunch of varying answers on the web, but they don't agree at all. What are my options? Manually create the table? Where would I put it?

As always, thanks for the help.

tim