Re: [cobalt-users] Extracting MySQL Data?

[Sergio Najera <sergion@xxxxxxxxxx>]

On Dec 3, 2003, at 1:55 PM, William J.A. Brillinger wrote:

> At 01:40 PM 03/12/03 -0800, you wrote:
>
> > On Dec 3, 2003, at 1:28 PM, William J.A. Brillinger wrote:
> >
> > > from the SSH command line: (not in mysql)
> > >
> > > mysqldump --all-databases --opt -uroot -pYOURPASSWORD > 
> > > YourTargetFileName.sql
> >
> > mysqldump: unrecognized option `--all-databases'
> >
> > -Sergio
>
> ok, you have an older version.
>
> Read here: http://www.mysql.com/doc/en/mysqldump.html
>
> Scroll down - it's a poorly laid out page :(
>
> - Bill

Thanks Bill,
I found a command that worked on that page,
mysqldump --opt database > backup-file.sql
(replaced "database" with the database I was trying to get)

I restored it on the new server, and it's half working (see below). I'm 
assuming the database is ok.

I'm now having problems with the program that was calling the database, 
PHPWebsite I belive it's called. It does not show me any "products", 
just categories.

Anyone have any idea on that one?

-Sergio