Wanted: Service MySQL help

[fish]

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]

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

 

[monaghanmonaghan is verified member.]

What are the errors?

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

 

[fish]

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]

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

 

[monaghanmonaghan is verified member.]

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]

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]

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

 

[monaghanmonaghan is verified member.]

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

<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

 

[monaghanmonaghan is verified member.]

Any joy yet? Site still looks down

Shout if you want a hand.