The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Download SQL backup error

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

  1. nisse

    nisse Well-Known Member

    Joined:
    Nov 11, 2003
    Messages:
    87
    Likes Received:
    0
    Trophy Points:
    6
    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