Moving MySQL database

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Omicron99
    Member
    • Jun 2005
    • 69
    • 3.0.7

    [Forum] Moving MySQL database

    I have a small forum, v3.8, thats 30mbs. I installed VB4 in another directory with another database. Using PHPmyAdmin I made a backup of my v3.8 database and want it import it into the Vb4 database. I can use PhPmyAdmin since it's a very small forum.

    My problem is that the V3.8 database tables start with "vb_" while the VB4 database does not, so it is not working. How do I get the backup database to overwrite the new one?
  • darren1981
    Senior Member
    • Oct 2007
    • 324
    • 4.0.x

    #2
    try dumping your website on a localhost and import there first, i believe you can add / remove prefixes via phpmyadmin.. (you could even remove these prefixes via notepad++)..

    as for overwriting it... i would make a BACKUP FIRST.... then delete / DROP your current db and import again, altho i don't see why you do not just run the update script ?

    Comment

    widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
    Working...
    😀
    😂
    🥰
    😘
    🤢
    😎
    😞
    😡
    👍
    👎