How does one restore their MySQL database from a tar.gz in Windows?

Rails
1

Thanks in part to all the help I received on this forum I’m up and
running with my web adventure developed in Windows XP. I’ve had this
fear creeping in with “what would I do if I had to restore the entire
database”?

I’ve got phpAdmin loaded upon my server and can access it except I
get
this error message:

" The mbstring PHP extension was not found and you seem to be using a
multibyte charset. Without the mbstring extension phpMyAdmin is
unable
to split strings correctly and it may result in unexpected results.
Your PHP MySQL library version 4.1.22 differs from your MySQL server
version 5.0.45. This may cause unpredictable behavior. "

As I use a Windows XP machine I expect I’ll be extracting this tar.gz
file somewhere and then running some type of routine to restore the
database. In Windows I use MySQL Administrator if I have to backup or
restore a database.

Can anyone explain the ‘big picture’ to me or point me where I can
learn this?
Thank you,
Kathleen

2

[email protected] wrote:

Can anyone explain the ‘big picture’ to me or point me where I can
learn this?
Thank you,
Kathleen

I cannot speak to the issues you are having with phpadmin on Windows,
but to restore a MySQL database then you must first decompress the .gz
file and then extract the files from the .tar archive. The you would
ahve to run mysql from the command line to recreate the DB. Something
like this:

mysql -u"username" -p"password" “dbname” < “dumpfile.mysql”

I am not clear on why you would wrap the dbdump in a tar file, unless
you have ancillary data that is contained in files external to the
database. If indeed you are backing up an entire site which depends
upon a mysql database then I suggest that you create a subdirectory at
the top level called dbdump and place your mysql dump in there first.

If you need a tar.gz extract utility for MS-windows then look here:
http://www.sfsu.edu/ftp/win/utils/powarc61.exe. WinZip also works and I
believe that XPproSP2 and above may have the extract capability built-in
to Windows Explorer.

3

Winrar can handle those and I know several other can too.

On Mon, Mar 17, 2008 at 9:08 AM, [email protected]
[email protected]