کشفیات بی ارزش

Tuesday, October 25, 2016

MySQL dump and Restore

To dump in UTF-8 compatible output:

 mysqldump [db] -u[user] -p --default-character-set=utf8 > [backup.sql]  

To load it back:
 mysql -u [user] -p [db] < [backup.sql]  
Posted by کاشف پاره‌وقت at 4:35 AM
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

No comments:

Post a Comment

Newer Post Older Post Home
Subscribe to: Post Comments (Atom)

About Me

کاشف پاره‌وقت
View my complete profile

Blog Archive

  • ►  2020 (1)
    • ►  May (1)
  • ►  2018 (6)
    • ►  October (1)
    • ►  August (1)
    • ►  July (1)
    • ►  June (1)
    • ►  May (1)
    • ►  March (1)
  • ►  2017 (12)
    • ►  October (6)
    • ►  August (1)
    • ►  July (1)
    • ►  April (2)
    • ►  March (2)
  • ▼  2016 (6)
    • ▼  October (1)
      • MySQL dump and Restore
    • ►  September (1)
    • ►  July (1)
    • ►  June (2)
    • ►  February (1)
  • ►  2015 (12)
    • ►  October (1)
    • ►  September (1)
    • ►  July (1)
    • ►  June (1)
    • ►  May (1)
    • ►  April (1)
    • ►  February (1)
    • ►  January (5)
  • ►  2014 (21)
    • ►  December (4)
    • ►  November (6)
    • ►  October (11)
Simple theme. Powered by Blogger.