<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
<title></title>
</head>
<body bgcolor="#000000" text="#99ffff">
As for myself I simply made a winods batch file, instructing windows
to perform a list of commends. I called MySQL Backup. A file I
run manualy. It contans this:<br>
<br>
cd /.<br>
cd program files<br>
cd MySQL<br>
cd MySQL Server 5.1<br>
cd bin<br>
mysqldump -u <root user name> -p<your password>
--databases opensim >\tmp\opensim.sql<br>
<br>
mysqldump comes with mysql 5.1 and higher, this batch file simply
sends commands to find it in my installed MYSQL directory where
mysqldump resides and gets all of my opwnsim's data, tables and all
and places it as a sql file into my TMP directory. Then I use a
program like 7zip to compress it to a 7z file that I burn to a DVD
or later once the backup becomes to large a set of DVD spanned
across several disk using 7zip.<br>
<br>
To restore my database I made another batch file I created and lucky
me, I only had to use once. It does prove that it worked though.
It looks like this.<br>
<br>
cd /.<br>
cd program files<br>
cd MySQL<br>
cd MySQL Server 5.1<br>
cd bin<br>
mysql -u <root user name. -p<your password> opensim <
/tmp/opensim.sql<br>
<br>
<br>
And this restores it for me. Once I unzip the sql file and place it
in my tmp directory folder. Of corse ,root user is your root user
name, and the password too. I took mine out for security reasons.<br>
<br>
Good luck, I wish you only the best.<br>
InuYasha.<br>
<br>
<br>
<br>
<br>
On 6/7/2011 8:36 PM, Mimetic Core wrote:
<blockquote cite="mid:4DEEC3F5.8000103@odosys.net" type="cite">HI
Missyfitz,
<br>
<br>
Many people will have their own recommendations for backing up
databases, all relative to their own experience levels. As far as
I'm concerned (even as a seasoned tech) tasks like database
management should be easy and require as little of our precious
time as possible. There's a great web-based tool for backing up
databases that I use and highly recommend to anyone of any
experience level called MySQLDumper. It's open source and can be
found here:
<br>
<br>
<a class="moz-txt-link-freetext" href="http://www.mysqldumper.net">http://www.mysqldumper.net</a>
<br>
<br>
I won't go into too many details as you can read about them for
yourself, but I will say that it can back up single/multiple
databases and compress them which makes archiving them very easy.
It takes about 1 minute to install and has a fairly
straightforward interface. It does require a functional web
server, preferably on the same machine as your SQL database(s)
which is usually the case.
<br>
<br>
Check it out. If you don't get all the info you need from the
site, I'll be happy to help you in any way I can as I've been
using MySQLDumper for some time now. Cheers.
<br>
<br>
core
<br>
<br>
On 6/7/2011 5:12 PM, missyfitz wrote:
<br>
<blockquote type="cite">What is the recommended method(s) for
doing a database backup? Is it simply a
<br>
matter of backing up the mySQL database file to external storage
or dvd, or
<br>
is there some method for exporting all the tables to a text
file? I've seen
<br>
reference to the latter someplace, but don't have it bookmarked
and am not
<br>
sure if that's the better way to go, or possibly the only way to
go...
<br>
<br>
Am I safe simply archiving the mySQL database file itself, or
should I be
<br>
using some method to export all the tables / data to a separate
file and
<br>
then archiving that file? If so, can you describe briefly how to
do the
<br>
export to grab all the database data, or point me in the right
direction?
<br>
Also, is there an automated way (WinXP) to do this, say, every 6
hours, or
<br>
is it best done manually?
<br>
<br>
(I'm a mySQL novice, as I'm sure many people here are, so I
think this info
<br>
clearly outlined would be beneficial to a lot of us)
<br>
<br>
--
<br>
View this message in context:
<a class="moz-txt-link-freetext" href="http://opensim-users.2152040.n2.nabble.com/Database-backups-recommended-methods-tp6451598p6451598.html">http://opensim-users.2152040.n2.nabble.com/Database-backups-recommended-methods-tp6451598p6451598.html</a><br>
Sent from the opensim-users mailing list archive at Nabble.com.
<br>
_______________________________________________
<br>
Opensim-users mailing list
<br>
<a class="moz-txt-link-abbreviated" href="mailto:Opensim-users@lists.berlios.de">Opensim-users@lists.berlios.de</a>
<br>
<a class="moz-txt-link-freetext" href="https://lists.berlios.de/mailman/listinfo/opensim-users">https://lists.berlios.de/mailman/listinfo/opensim-users</a>
<br>
</blockquote>
<br>
_______________________________________________
<br>
Opensim-users mailing list
<br>
<a class="moz-txt-link-abbreviated" href="mailto:Opensim-users@lists.berlios.de">Opensim-users@lists.berlios.de</a>
<br>
<a class="moz-txt-link-freetext" href="https://lists.berlios.de/mailman/listinfo/opensim-users">https://lists.berlios.de/mailman/listinfo/opensim-users</a>
<br>
<br>
</blockquote>
<br>
<br>
<pre class="moz-signature" cols="72">--
________________________________________________________________
Opensim User: Standalone Grid on Version 0.7.1.1 with 49 Regions
on Windows 7, 64-bit. Phenom 9500 2.2 ghz Quad Core, Terabyte Hard
Drive, 8gig DDR2 RAM. Used XAMPP to load PHP Version 5.3.0, Apache
and MySQL 5.1.41-community edition. Modules not yet successful
________________________________________________________________
</pre>
</body>
</html>