WordPress.org

1. Sam_a
   Member
   Posted 6 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"
   • "Add AUTO_INCREMENT"
   • "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
   Member
   Posted 6 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
   Member
   Posted 6 years ago #

   Thanks, alphaoide.

   I added this to the Codex (corrections welcome):

   http://codex.wordpress.org/Backing_Up_Your_Database#Using_CocoaMySQL

Topic Closed

This topic has been closed to new replies.