Import/Export MySQL database question

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • dfinkle
    Member
    • Oct 2001
    • 67
    • 3.0.7

    Import/Export MySQL database question

    Hi all,
    I'm moving web hosts today, and I have to move my vbulletin's mysql db as well. I'm using VB version 3.6.2. I did a database dump using phpmyadmin. I uploaded the .sql file to a temporary area for my host's tech support to import into the new database, but they replied, "Your file has a create database line in it. Please remove that line or export it again without create database checked." I don't see any option in phpmyadmin for create database. I opened up the sql file and I see this:
    Code:
    CREATE DATABASE `tkahike_vbulletin` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
    USE `tkahike_vbulletin`;
    Should I leave the "USE 'tkahike_vbulletin'; part or delete the whole thing? Thanks for any help you could provide!
    New Jerseyans- Beat Your Traffic Ticket!!
    http://www.njtrafficfines.com
  • Wayne Luke
    vBulletin Technical Support Lead
    • Aug 2000
    • 74166

    #2
    Delete both lines.
    Translations provided by Google.

    Wayne Luke
    The Rabid Badger - a vBulletin Cloud demonstration site.
    vBulletin 5 API

    Comment

    • dfinkle
      Member
      • Oct 2001
      • 67
      • 3.0.7

      #3
      Thank you.
      New Jerseyans- Beat Your Traffic Ticket!!
      http://www.njtrafficfines.com

      Comment

      widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
      Working...