creating and backing up table

[dean]

Seemed like a good time to jump in and run my mouth. Phorum came with a file called add.sql. The fastest way to set up the table is using mysql from a telenet prompt.

The command is:
mysql -pyour_password -uyour_mysql_login database_name <file.name

This is also useful to backup and restore your databases. To backup:
mysqldump -pyour_password -uyour_mysql_login database_name > backupfile.name

This mysqldump creates a text file that should be saved and can be edited http://www.aota.net/ubb/smile.gif

dean morrison

<added>
arg http://www.aota.net/ubb/frown.gif I intended this message to be part of the phorum thread below.
</added>

[This message has been edited by dean (edited 04-19-99).]

[Dean B]

Excuse me, that's Dean with a capital 'D' http://www.aota.net/ubb/wink.gif

[Justin]

I'm glad you mentioned that - I've been wondering about backing up a database, as I am working on a new site right now, and hopefully the database I'm using will grow and grow. The thought that something could happen... eek! I will definately want to back it up regularly, as every entry will be entered by hand by me, and that's a lot of work to lose http://www.aota.net/ubb/smile.gif

Thanks for the tip there http://www.aota.net/ubb/smile.gif Funny thing is I couldn't figure out how to use the add.sql file and ended up just creating the table on the command line manually http://www.aota.net/ubb/smile.gif I just copy/pasted the contents of the file though http://www.aota.net/ubb/smile.gif

------------------
Justin Nelson
FutureQuest Support

[dean]

A flood of deans wow! :P