Database problems

[TWA]

I have a 000webhost account and I'm trying to export my phpBB3 and Wikimedia databases to my BWF account but it's not working.

I've tried exporting from the 000webhost which gave me a .sql file then I tried importing it to the BWF account and it didn't work. I then did a backup and tried importing that but it still didn't work.

It's really annoying because I payed for the BWF account and the customer support ran me through everything they could do and still nothing.

Can anyone help me here? I've got a nice snappy site but with no wiki and forum and it's really annoying!

 

[Dr. ProXicon]

Does your host have/support phpMyAdmin?

 

[TWA]

Yes it does have phpMyAdmin, it's what I used to import the databases, but they either come up blank or not come up at all.

 

[Rich Edmonds]

1. You are pasting the actual contents of the .sql file into the import section of the new database right?

2. You have actually created a blank database where you wish to import your old one into, yes?

3. How do you mean it's just "blank"?


Post back with answers to the above -happy-

 

[TWA]

1) The .sql file was generated by exporting the database from my 000webhost account (from phpMyAdmin)
2) No, I didn't... Was I meant to?
3) A new database is created and shows up in phpMyAdmin but has nothing in it

 

[Dr. ProXicon]

If everything was exported correctly out of phpMyAdmin, there should've been a LARGE Text Box with a lot of words in it.

Copy EVERYTHING visible within the Text Box -> Paste in Notepad -> Save as db_sqldata.txt.

Alter your config for the new database, and import everything from the .txt file back into phpMyAdmin.

 

[Rich Edmonds]

Remember to create a database if needs be, call it what your previous database was called if you want. If there is no database your tables won't populate as there is nowhere for them to go.

 

[TWA]

It worked! Thanks a lot, Dr. ProXicon!!!!

 

[Dr. ProXicon]

It worked! Thanks a lot, Dr. ProXicon!!!!

Not a problem m8. 🙂 Happy to help.

 

[TWA]

Just tried to do some more work on it and discovered not all is perfect yet... When I upload the wiki file after the forum, or vice versa, it uploads into a existing database which already has stuff in it instead of a new one. I tried to make a new blank database manually before uploading but I can't find how.