Go Back   EQEmulator Home > EQEmulator Forums > Archives > Archive::Development > Archive::Database/World Building
Reload this Page quick question, how to backup my database..

Archive::Database/World Building Archive area for General Discussion's posts that were moved here after an inactivity period of 90 days.

Reply
 
Thread Tools Display Modes
  #1  
Old 02-08-2004, 10:33 PM
Swiftwing
Fire Beetle
  
Join Date: Feb 2004
Posts: 12
Default quick question, how to backup my database..
I cant remember the comand to save a database, anyone know, I need to take my working DB and dump it to a safe directory for storage
Reply With Quote
  #2  
Old 02-08-2004, 10:40 PM
samandhi's Avatar
samandhi
Demi-God
  
Join Date: Aug 2003
Posts: 1,056
Default
not totally sure of the SQL command forf this, but if you get MySQLFront, you can just click export and save as .sql or .htm and so on. ..... ....
__________________

Quote:
Analysis paralysis will keep you from failing, but it will also keep you from succeeding.
  • L.L. CoolJ
Reply With Quote
  #3  
Old 02-09-2004, 12:58 AM
Trumpcard
Demi-God
  
Join Date: Jan 2002
Location: Charlotte, NC
Posts: 2,614
Default
mysqldump <databasename> <tablename>

mysqldump database will dump all the tables for that database, just redirect it into a text file ( > somefile.sql )
__________________
Quitters never win, and winners never quit, but those who never win and never quit are idiots.
Reply With Quote
  #4  
Old 02-09-2004, 02:54 AM
Monrezz's Avatar
Monrezz
Dragon
  
Join Date: Mar 2003
Location: #loc
Posts: 745
Default
mysqldump eq > Backup.sql

Will backup your whole database into a file called Backup.sql. To restore the database just drop your current one and then source in the file.

Monrezz
__________________

kRPG Profile
Reply With Quote
Reply

« Previous Thread | Next Thread »

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

   

All times are GMT -4. The time now is 02:19 AM.

EQEmulator - Archive - Top

 

Everquest is a registered trademark of Daybreak Game Company LLC.
EQEmulator is not associated or affiliated in any way with Daybreak Game Company LLC.
Except where otherwise noted, this site is licensed under a Creative Commons License.
       
Powered by vBulletin®, Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Template by Bluepearl Design and vBulletin Templates - Ver3.3