Results 1 to 3 of 3
  1. #1
    Join Date
    May 2003
    Posts
    847

    DB one size only !!!

    Hi

    I sometime try to take DB files for my client using this code

    mysqldump -u root -p XXXXXXX >name_db.sql

    but all times the DB (sql file) = size 6KB only !! and the real DB size = 15MB

    any idea ??

  2. #2
    You need to specify the database(s) you want to dump:

    > mysqldump -uroot -p --all-databases > all-databases-040405.sql

    or:

    > mysqldump -uroot -p some_database > some_database_040405.sql

    Note also that I did not include the password in the command, used just the -p. After pressing Enter, you can enter your password. This is really important if you are working on a server with other users because a less privileged user looking at, say, 'top' could see your root password!
    Last edited by FirstInShow; 04-05-2004 at 11:32 AM.

  3. #3
    [This was to correct an error in my above post, but it was less confusing to edit the first message...but I can't delete this one!]
    Last edited by FirstInShow; 04-05-2004 at 11:37 AM.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •