[geeklog-users] db backup, how to use it?

[geeklog-users-admin at lists.geeklog.net]

Scroff wrote:

>I did a db backup through gl db backup. I
>have myphpadmin, what do i do with the backup to restore? 

Create a new database (if you haven't already done so) and select it. On
recent versions of phpMyAdmin, you will see a tab labelled "SQL" - select
that. There's a browse button there that lets you select your backup file
(to upload it to your webserver, so you may have to download it first).
Click on "Go" and it should import it.

However, you may run into a timeout when you have a huge database. In
that case, doing it from the command line (if you have SSH or telnet
access) would be better:

    mysql -u[username] -p -D [database_name] < backup_file.sql

replacing [username] and [database_name] with the obvious information ...

bye, Dirk


-- 
http://www.haun-online.de/
http://www.macosx-faq.de/