Support » Fixing WordPress » Export database with CocoaMySQL, how to?

  • Resolved Sam_a


    I’d like to use CocoaMySQL to make a database backup, but I’m not sure what the correct export settings are.

    The Codex article Backing up your database says these options should be checked when exporting with phpMyAdmin:

    • “Add DROP TABLE”
    • “Enclose table and field names with backquotes”

    In CocoaMySQL, File > Export > MySQL dump… brings up a save dialog with these options only:

    • Add drop table
    • Add create table
    • Add table content
    • Add errors to dump file

    Which should I use? I did an export with Add drop table + create table + table content; looks like this:

    # CocoaMySQL dump
    # Version 0.5
    # Host: localhost (MySQL 4.0.26-standard)
    # Database: wordpress
    # Generation Time: 2005-11-21 09:02:00 -0800
    # ************************************************************

    # Dump of table wp_categories
    # ------------------------------------------------------------

    DROP TABLE IF EXISTS wp_categories;

    CREATE TABLE wp_categories (
    cat_ID bigint(20) NOT NULL auto_increment,
    cat_name varchar(55) NOT NULL default ”,
    category_nicename varchar(200) NOT NULL default ”,
    category_description longtext NOT NULL,
    category_parent int(4) NOT NULL default ‘0’,
    PRIMARY KEY (cat_ID),
    KEY category_nicename (category_nicename)
    ) TYPE=MyISAM;

    INSERT INTO wp_categories (cat_ID,cat_name,category_nicename,category_description,category_parent) VALUES (“1″,”Uncategorized”,”uncategorized”,””,”0″);
    INSERT INTO wp_categories (cat_ID,cat_name,category_nicename,category_description,category_parent) VALUES (“3″,”News”,”news”,””,”0″);

Viewing 2 replies - 1 through 2 (of 2 total)
Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Export database with CocoaMySQL, how to?’ is closed to new replies.