RE: [cobalt-users] Extracting MySQL Data?

["Phil Beynon" <phil@xxxxxxxxxxxxxxxxxxxxxxxxx>]

> 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

Have you created a user with the same rights on the new server as the old?

Phil

** http://www.diygear.com THE Online DIY Toolstore For DIY & Business
** Infolink Electronic Systems Ltd. http://www.infolinkelectronics.co.uk
** Professional Web Design & Cobalt Hosting Solutions
** Sun Cobalt iForce Reseller - Canon Silver Reseller
** Contact: Sales@xxxxxxxxxxxxxxxxxxxxxxxxx
** Tel / Fax 0121 458 4894 (office) 0121 441 3558 (home)