Help Needed!

[gomarc]

i mean that you give the job to gomarc and he will do it for you

Thank you, I appreciate that.

 

[cgrim29588]

Thanks for your help gomarc!

 

[garrettroyce]

Sorry I missed your IM, I was playing Bioshock and got distracted

 

[cgrim29588]

I'm having problems restoring the database on the new server.

 

[garrettroyce]

What kind of database is it? (version and type)

 

[gomarc]

@ cgrim29588

Database and public_html transfer complete.


@ garrettroyce

MySQL version 2.11.9.5

 

[garrettroyce]

WOW 2.11?

X10 -> 5.0.77-community

You can't export it as a sql file, because I'm sure something has changed in the syntax. You'll have to export it as a CSV.

 

[gomarc]

WOW 2.11?

X10 -> 5.0.77-community

You can't export it as a sql file, because I'm sure something has changed in the syntax. You'll have to export it as a CSV.

Correction, yes MySQL version 5.0.77-community

 

[garrettroyce]

Ah, much better

You got it all done then?

 

[gomarc]

Yep, all done and in place. The pending task for cgrim29588 is to change database name / user / pass to the new specifications.

 

[bree623]

Why are we getting this message still...

IPS Driver Error

There appears to be an error with the database.
You can try to refresh the page by clicking here
Edit:
This topic can be closed, I finally got it to work.

 

[gomarc]

Why are we getting this message still...

IPS Driver Error

There appears to be an error with the database.
You can try to refresh the page by clicking here

That’s because the database of the new site has a different name than the one it was copied from. You just can’t avoid it when your cpanel usernames are different.

Say your create a db named “users” This name gets transformed into

"your Cpanel name _ users"

So when you want to connect to the database, your db name is “yourCpanelname_users”.

If you host somewhere else and have a different CPanel user name, your db name will also change to “yourNewCPanelName_users”.

One way of fixing this is to have the new CPanel name be the same as your old one. I’m not sure if it is possible, but it’s worthwhile trying.

Another way of doing it is to change your code. You will have to edit/change your code for this solution to work, changing the name of the database in your code

From:
yourCpanelname_users

to:
yourNewCPanelName_users