restore backup

[hollyhock]

I'm also having problems trying to restore a backup. I'm testing on another webhost (Flexihostings) to see if it's GoDaddy that's making things slow, and I installed 2.5.5 there. I have 2.5.5 on the GoDaddy shared plan as well.

When I tried to import my database using the backup feature (I used pmf's back up to get the SQL file from the GoDaddy host and back up to import it back in), it just didn't work -- no error messages or anything.

I've never really tried to populate a database before, so maybe someone can help me out?

[hollyhock]

I should add that all the table names are different in each one. On the GoDaddy host, they're all prefixed with pmf_, probably because it was an upgrade? In the Flexihostings MySQL database, none of the tables have the pmf_ prefix

[Thorsten]

Hi,

the table prefixes have to be identical otherwise it won't work.

bye
Thorsten

[hollyhock]

Okay, so I did a find/replace and took out all the prefixes but there seems to be a problem with anything of an index key of "1" especially concerning admin accounts. It just stops importing the data. Are there any tables in particular that I can import individually just to get my questions back?

[Thorsten]

Hi,

you can send me your dump by e-mail and I can check this.

bye
Thorsten

[hollyhock]

Hi Thorsten,

I emailed you at thorsten [at] rinne.info on Wednesday. Is this the correct email?

[Thorsten]

Hi,

I received the mail, but I didn't had the time to look into it yet.

bye
Thorsten

[hollyhock]

Ok, no worries.

[Thorsten]

Hi,

I could remove all SQL prefixes and import the database without any problems.

bye
Thorsten

[hollyhock]

Thorsten,

I don't know if you have a copy of it with all the prefixes removed, but would you mind sending it to me? I tried again yesterday evening removing all the prefixes and it didn't work, for whatever reason.

Another thought -- is caching enabled?

Nellie

[Thorsten]

Hi,

sure... but I deleted your dump. Sorry, could you please re-send it to me?

bye
Thorsten