Database issues

[DuCe]

Alright webmasters,

I been having this problem importing my old database from my site and I thought someone from this site may be able to help me seeing as this is a webmasters site.

I had a website not too long ago, then there was a power outage where I live at (Florida) which happens alot. This power outage fried my charger, and the piece where you connect it. Now with the few minutes I had left with power on my laptop I made a backup of my site just in case I was not going to be able to keep paying it (because I might not have my laptop), so anyways I made these backups of everything. The hosting was under BeastGamers, now its under WarezDesign, the db is from WarezDesign, but the database name ware "Beastgam_vb" now since the hosting is under warezdesign the db name is "warezdes_vb" but it keeps saying I am having database issues (The database has encountered a problem.).

Is there anything I need to change or do to my database to make it work?

I do not know much about databases, but I do know how to follow instructions. Can anyone help?

Any questions? Feel free to ask ill be around this site alot.

Please do not post if you are not trying to help. I will appreciate it very much if you have any knowledge on this, and wish to help me.

DuCe Reviewed by DuCe on 31st Jan 2010. Database issues Alright webmasters, I been having this problem importing my old database from my site and I thought someone from this site may be able to help me seeing as this is a webmasters site. I had a website not too long ago, then there was a power outage where I live at (Florida) which happens alot. This power outage fried my charger, and the piece where you connect it. Now with the few minutes I had left with power on my laptop I made a backup of my site just in case I was not going to be able Rating: 5

[delboy]

Hello,
1) Open the .sql dump into TextPad/NotePad++, And remove all the junk like the below..

-- Dump by Phpmyadmin
/*!40101 SET NAMES 'utf8' */;
SET FOREIGN_KEY_CHECKS=0;

2) once its tidyed up, just import my mysqldumper or bigdump using latin1. (depending on your db size you may be able to use phpmyadmin)

[DuCe]

Hello,
1) Open the .sql dump into TextPad/NotePad++, And remove all the junk like the below..

-- Dump by Phpmyadmin
/*!40101 SET NAMES 'utf8' */;
SET FOREIGN_KEY_CHECKS=0;

2) once its tidyed up, just import my mysqldumper or bigdump using latin1. (depending on your db size you may be able to use phpmyadmin)

I did it but it didn't work...

[delboy]

I did it but it didn't work...

what error are you getting ???

[SuicidalMedia]

Did you edited includes/config.php with new details?

[DuCe]

what error are you getting ???

Same one.

Did you edited includes/config.php with new details?

Yes I did. I know that much.

[SuicidalMedia]

Well my friend,
I can see that you don't have this table.

MySQL Error : Table 'warezdes_name.datastore' doesn't exist

But you need it.

[delboy]

Same one.

Ah 'warezdes_name.datastore' doesn't exist.. i assume it it is Beastgam_name.datastore in your db?

[DuCe]

Now I am lost mate.

[SuicidalMedia]

You need to have datastore table mate. Understand that?