[resolved] Export database with CocoaMySQL, how to? (3 posts)

  1. Sam_a
    Posted 10 years ago #

    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
    # http://cocoamysql.sourceforge.net
    # 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");

  2. Joshua Sigar
    Posted 10 years ago #

    Yeah, the options you select give the correct output. EXCEPT, you should be able to select multiple tables.

    WP has around 9 (not sure) tables; you have to back up all of them.

  3. Sam_a
    Posted 10 years ago #

    Thanks, alphaoide.

    I added this to the Codex (corrections welcome):


Topic Closed

This topic has been closed to new replies.

About this Topic