1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

MySQL export/import

Discussion in 'MySQL' started by sasamsa, Feb 15, 2006.

0
  1. #1
    I have some problems importing local database to server.
    I have joomla running on localhost with wamp sql version MySQL 5.0.18-nt and on server MySQL 4.0.25-standard.
    How do I export from localhost to server?
    both have phpMyAdmin 2.7.0-pl2
    When I export with default settings ant try to import to server it says:
    #1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'DEFAULT CHARSET=latin1 AUTO_INCREMENT=3' at line 19

    When I set MySQL compatibility to MYSQL40, export and try to import it says:
    #1046 - No Database Selected

    What to do?
     
    sasamsa, Feb 15, 2006 IP
  2. Perrow

    Perrow Well-Known Member

    Messages:
    1,306
    Likes Received:
    78
    Best Answers:
    0
    Trophy Points:
    140
    #2
    Insert a line in the beginning of your sql-sqript saying:

    use database_name;

    where database_name is the name of your database. that should take care of the #1046 error.
     
    Perrow, Feb 15, 2006 IP
    sasamsa likes this.
  3. sasamsa

    sasamsa Peon

    Messages:
    63
    Likes Received:
    2
    Best Answers:
    0
    Trophy Points:
    0
    #3
    Ok, that worked. Thank you very much
     
    sasamsa, Feb 15, 2006 IP