Rails - Mar 2008 - How does one restore their MySQL database from a tar.gz in Windows?

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


--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---

KathysKode-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org 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.
-- 
Posted via http://www.ruby-forum.com/.

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---

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

On Mon, Mar 17, 2008 at 9:08 AM,
KathysKode-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org
<KathysKode-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org>
wrote:
>
> 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
>
>
> >
>
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---