skip to main | skip to sidebar

花落无声

Showing posts with label mysql maintains production. Show all posts
Showing posts with label mysql maintains production. Show all posts

Tuesday, May 10, 2011

export and import ddl from mysql

export ddl for mysql database

mysqldbexport --server=username:passassword@hostname_or_ip --skip=GRANTS --export=DEFINITIONS schema_name > foo.sql


mysqldbimport --server=username:password@hostname_or_ip --skip=GRANTS --import=DEFINITIONS foo.sql
Posted by 紫气东来 at 2:54 AM No comments:
Labels: mysql maintains production
Older Posts Home
Subscribe to: Posts (Atom)

Blog Archive

  • ▼  2021 (1)
    • ▼  December (1)
      • 2021 MacBook M1 monterey mariadb slow
  • ►  2015 (6)
    • ►  May (6)
  • ►  2011 (10)
    • ►  November (2)
    • ►  July (3)
    • ►  May (5)
  • ►  2010 (27)
    • ►  September (2)
    • ►  July (2)
    • ►  June (8)
    • ►  May (3)
    • ►  April (8)
    • ►  March (1)
    • ►  February (2)
    • ►  January (1)
  • ►  2009 (47)
    • ►  December (10)
    • ►  November (10)
    • ►  September (8)
    • ►  August (4)
    • ►  July (7)
    • ►  June (2)
    • ►  May (2)
    • ►  April (3)
    • ►  January (1)
  • ►  2008 (8)
    • ►  August (3)
    • ►  July (2)
    • ►  June (2)
    • ►  March (1)
  • ►  2007 (30)
    • ►  November (1)
    • ►  September (1)
    • ►  August (2)
    • ►  July (1)
    • ►  June (4)
    • ►  May (7)
    • ►  April (10)
    • ►  March (1)
    • ►  January (3)
  • ►  2006 (2)
    • ►  December (1)
    • ►  September (1)

Links

  • Google News

About Me

紫气东来
View my complete profile