MySQL help

fish · 06-09-2007, 09:53:17 AM

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 · 06-09-2007, 10:09:59 AM

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 · 06-09-2007, 10:24:03 AM

What are the errors?

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

fish · 06-09-2007, 10:48:49 AM

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 · 06-09-2007, 03:52:16 PM

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 · 06-09-2007, 04:02:47 PM

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 · 07-09-2007, 08:47:47 AM

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 · 07-09-2007, 09:14:30 AM

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 · 07-09-2007, 09:36:35 AM

Quote:

Originally Posted by fish

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 Code:

<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

monaghan · 10-09-2007, 10:59:49 AM

Any joy yet? Site still looks down

Shout if you want a hand.

06-09-2007, 09:53:17 AM	#1 (permalink)
fish Join Date: Nov 2006 Posts: 2,316 No Classified Ratings Domain Trader Rating: (100% / 46)	MySQL help 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

06-09-2007, 10:24:03 AM	#3 (permalink)
monaghan Join Date: May 2007 Posts: 1,148 No Classified Ratings Domain Trader Rating: (100% / 7)	What are the errors? As a web host, the obvious question is "Why isn't your host helping you resolve this?" __________________ Alex Monaghan - Drop Catch & Drop Lists - PM for details Online Accounting\|Pine Furniture\|Barbie

06-09-2007, 04:02:47 PM	#6 (permalink)
monaghan Join Date: May 2007 Posts: 1,148 No Classified Ratings Domain Trader Rating: (100% / 7)	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). __________________ Alex Monaghan - Drop Catch & Drop Lists - PM for details Online Accounting\|Pine Furniture\|Barbie

10-09-2007, 10:59:49 AM	#10 (permalink)
monaghan Join Date: May 2007 Posts: 1,148 No Classified Ratings Domain Trader Rating: (100% / 7)	Any joy yet? Site still looks down Shout if you want a hand. __________________ Alex Monaghan - Drop Catch & Drop Lists - PM for details Online Accounting\|Pine Furniture\|Barbie

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

06-09-2007, 10:09:59 AM	#2 (permalink)
tifosi Join Date: Oct 2004 Location: Lancashire Posts: 1,907 No Classified Ratings Domain Trader Rating: (100% / 9)	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

06-09-2007, 10:48:49 AM	#4 (permalink)
fish Join Date: Nov 2006 Posts: 2,316 No Classified Ratings Domain Trader Rating: (100% / 46)	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

06-09-2007, 03:52:16 PM	#5 (permalink)
fish Join Date: Nov 2006 Posts: 2,316 No Classified Ratings Domain Trader Rating: (100% / 46)	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

07-09-2007, 08:47:47 AM	#7 (permalink)
fish Join Date: Nov 2006 Posts: 2,316 No Classified Ratings Domain Trader Rating: (100% / 46)	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

07-09-2007, 09:14:30 AM	#8 (permalink)
redbird Join Date: Sep 2005 Location: Worcester Posts: 898 No Classified Ratings Domain Trader Rating: (100% / 35)	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

Similar Threads
Thread	Thread Starter	Domain Name Community	Replies	Last Post
Need someone in mySql or like for biggish project	GWing	Services Wanted	10	23-07-2007 03:49:34 PM
MySql Select statement help please	admin	Website Design	15	05-07-2007 10:55:17 AM
Help! MySQL guru req'd	scooter	Services Wanted	10	29-06-2007 11:18:39 AM
moving mysql from one server to another	SecNam	General Board	1	07-08-2005 12:29:32 PM