Jump to content

Importing DB


Recommended Posts

So I need to import a database into PHPmyAdmin. The database I have was exported from phpbb2, it's a .sql. Can I simply import that database in PHPmyAdmin? I currently have a database created in phpmyadmin with no tables. Should I completely delete the database before uploading?When importing I have multiple choices of character encoding, I'm not sure which one to choose. The 2 I recognize are UTF8 and ASCII. Which one should I choose? Also there is a compatibility mode to select. The backed up db was done on a mysql server so I guess I should choose mysql40 or mysql323, right?

Link to post
Share on other sites

Can you go back and use phpadmin to export the "stucture only" and then export the tables one or two at a time?You should then be able to IMPORT them using phpadmin again???

Link to post
Share on other sites

We have the db up and running now. Everything works great except an rss feed with had which gave us the 15 most recent posts. It doesn't seem to work anymore... The database is the same, except it's 1 week old.Here is the error we have.

Could not query list of active postsDEBUG MODESQL Error : 1030 Got error 122 from storage engineSELECT f.forum_name, t.topic_title, u.user_id, u.username, u.user_sig, u.user_sig_bbcode_uid, p.post_id, pt.post_text, pt.post_subject, pt.bbcode_uid, p.post_time, t.topic_replies, t.topic_first_post_id FROM phpbb_forums AS f, phpbb_topics AS t, phpbb_users AS u, phpbb_posts AS p, phpbb_posts_text as pt WHERE t.forum_id = f.forum_id AND f.auth_Read = 0 AND p.poster_id = u.user_id AND pt.post_id = p.post_id AND p.topic_id = t.topic_id ORDER BY p.post_time DESC LIMIT 15Line : 165File : rss.php
Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
×
×
  • Create New...