Wanted: Service MySQL help

fish · Sep 6, 2007

My website has been moved to a new host which only supports MySQL 5, previously the site was using an older version (not sure which).

I have the data saved as a dump file but naturally it won't drop in v.5 of mysql.

Can anyone offer advice as what's needed to do this?

Thanks,

Howie

tifosi · Sep 6, 2007

Without seeing what the errors are when you try the dump it's hard to tell. There were some large changes between 4.0 & 4.1 and 4.1 & 5.0.

Quite possibly it's an index that is now not correct, e.g an index on a text field of 0 chars where this should be 1+.

e.g CREATE TABLE `info` (
`id` int(11) NOT NULL auto_increment,
`text` text NOT NULL,
PRIMARY KEY (`id`),
KEY `text` (`text`(0))
);

which should be `text` (`text`(1))

The mysql site shows other changes

monaghan · Sep 6, 2007

What are the errors?

As a web host, the obvious question is "Why isn't your host helping you resolve this?"

fish · Sep 6, 2007

thanks to monaghan & tifosi for the quick responses.

- As a web host, the obvious question is "Why isn't your host helping you resolve this?"

that's a good Q, the short answer is that I have not asked them but am going to right now! (the last hosts were no help at all (why I've moved) and were only interested in taking cash off me on a regular basis

cheers,

Howie

fish · Sep 6, 2007

have been referred to the MySQL site by the new hosts...

If I were tech minded then I would ;

a) understand the reference manual :???:
b) done it allready

would anyone care to help for a small fee??

thnx

Howie

monaghan · Sep 6, 2007

Good support from your new host as well then

Post the error message (or PM if you'd prefer) and I'll have a look at it later (have to go out and deliver a PC now).

fish · Sep 7, 2007

Update.... I have managed to sort of, sort this out.

However there's still acouple of glitches

I had to rename the dump file in order for it to drop into MySQL (simple really if you know what to do)

I also changed; $CFG->dbname , $CFG->dbuser & $CFG->dbpass with appropriate info.

This allowed me to partially access my site.

I uploaded the server with the same page files that I used previously, I've not changed any of the PHP (save from above) but am now getting page not found error . see www. collectablefish.com.

Some pages work, i.e. the about us page, the links page but the main page links down the centre of the site get an error. Also the pics don't load on these either. The files are on the server! I just don't know why it's not seeing them.

I'm not tech savvy and have only got this far by a process of elimination. But am now stumped good and proper.

anything I can try? any suggestions?

all help appreciated!

thnx

Howie

redbird · Sep 7, 2007

As far as images are concerned they do not seem to exist on the server.
example missing image is http://www.collectablefish.com/images/1.jpg

go to http://www.collectablefish.com/images/ to get a list of images on your server.
Have they been uploaded to a different folder other than images?

Dave

monaghan · Sep 7, 2007

fish said:
I uploaded the server with the same page files that I used previously, I've not changed any of the PHP (save from above) but am now getting page not found error . see www. collectablefish.com.

Some pages work, i.e. the about us page, the links page but the main page links down the centre of the site get an error. Also the pics don't load on these either. The files are on the server! I just don't know why it's not seeing them.

Looks like you've not uploaded all your images

This code extract from the main page

HTML:

<div class="image">
    <a href="http://www.collectablefish.com/item_list.php?c_id=1"><img src="http://www.collectablefish.com/images/1.jpg" width="90" height="80" alt="Fish Platter - Fish Plate - Fish Dish -  Fish Bowl" border="0"></a>
  </div>

If you look at http://www.collectablefish.com/images/ you'll see that the 1.jpg is missing

If you look at the error when you click the link, then it's suggesting that you don't have all your PHP code installed.

I would suggest re-loading your site from your backup (or original design) as there may be other critical files missing as well.

I still fail to see why your new host is unable to help, you might want to re-consider your choice of host