No announcement yet.

My SQL Dump Problem - pls assist!

  • Filter
  • Time
  • Show
Clear All
new posts

  • My SQL Dump Problem - pls assist!

    Hi, I was wondering if anyone can help me figure this out.
    I always do mysql dumps thought the years of running this forum.
    I do it to backup the db.

    Today I tried doing it via the shell as always. Everything normal.
    Seems to be working. Then when looking at the dumped .sql file
    it is 0kb. Empty.

    Any ideas on why? I need to backup this forum because its moving
    servers. Any help would be appreciated!

  • #2
    Do you include the password in your commandline?

    For security reasons, you can no longer do something like:
    mysqldump -ufeldon23 -pXXXXXXX --opt db_name > backup.sql

    You must do
    mysqldump -ufeldon23 -p --opt db_name > backup.sql
    and enter the password manually.


    • #3
      Yes, that is what I did.
      I have done it many times.

      This hangs like usual whicle creating the dump.
      It creates the file name - but it is Zero Kilobytes. db is at least 500 mb in size

      Does anyone have any ideas? I relly need to solve this issue.


      widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.