Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

Download SQL backup error

Discussion in 'Database Discussion' started by nisse, Aug 15, 2004.

  1. nisse

    nisse Well-Known Member

    Joined:
    Nov 11, 2003
    Messages:
    87
    Likes Received:
    0
    Trophy Points:
    156
    Backups created using the "Download a MySQL Database Backup" option will not restore if any of the table or field names contain the "-" character.

    Example of results using "Download a MySQL Database Backup":

    Code:
    CREATE TABLE test-table (
      test-field tinyint(4) NOT NULL default '0',
    ) TYPE=MyISAM;
    Example of results from WHM-generated full backup:

    Code:
    CREATE TABLE `test-table` (
      `test-field` tinyint(4) NOT NULL default '0',
    ) TYPE=MyISAM;
    In the first example, the quotes around the table and field names are missing. This backup will not restore, while the WHM backup restores correctly.
     
Loading...

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice