Re: [Fofredux-devel] Clean install problem

[Andrew T. (nilspace) <nil...@us...>]

The easiest way to 'backup' a mysql database, if you still have access
to the db, is to use mysqldump:

$> mysqldump -u username -p dbname -h hostname > dbname_backup_YYYYMMDD.sql

or something similar.

On 12/30/05, Miles Beck <mil...@gm...> wrote:
> On 12/29/05, Kevin <ke...@dr...> wrote:
> > Check to make sure the mysql module is loaded.   In php.ini, you should
> > have a line like this:
> >
> > extension=3Dmysql.so
> >
> > If this exists already, try restarting your webserver.
> >
> > Are you using the apache module, or CGI version of php?   The php.ini
> > file is in different locations for each.  You may have the extension
> > loaded in one place but not the other.
> >
> > -Kevin.
>
> Thanks. That did the trick.
>
> Now I have a question on whether or not I backed up the right database
> files in case there was a problem with my server. The last backup I
> did was on Friday. If I got the right files I'd like to restore the
> database using them. The files I have are:
>
> -rw-r--r--  1 mysql mysql    8660 2005-12-29 15:57 px_feeds.frm
> -rw-r--r--  1 mysql mysql    9204 2005-12-29 15:57 px_feeds.MYD
> -rw-r--r--  1 mysql mysql    2048 2005-12-29 15:57 px_feeds.MYI
> -rw-r--r--  1 mysql mysql    8874 2005-12-29 15:57 px_items.frm
> -rw-r--r--  1 mysql mysql 8722160 2005-12-29 15:57 px_items.MYD
>
> If those are the right files what is the best way to restore the database=
?
>
> -Miles
>
>
> -------------------------------------------------------
> This SF.net email is sponsored by: Splunk Inc. Do you grep through log fi=
les
> for problems?  Stop!  Download the new AJAX search engine that makes
> searching your log files as easy as surfing the  web.  DOWNLOAD SPLUNK!
> http://ads.osdn.com/?ad_idv37&alloc_id=16865&opclick
> _______________________________________________
> Fofredux-devel mailing list
> Fof...@li...
> https://lists.sourceforge.net/lists/listinfo/fofredux-devel
>


--
Andrew Turner
ajt...@hi...        42.4266N x 83.4931W
http://highearthorbit.com              Northville, Michigan, USA