Unsupported Screen Size: The viewport size is too small for the theme to render properly.

Importing Data From 1 Databse To Another, On The Same Host.

forums › forums › SQLyog › Using SQLyog › Importing Data From 1 Databse To Another, On The Same Host.

  • This topic is empty.
Viewing 3 reply threads
  • Author
    Posts
    • February 7, 2007 at 5:35 am #23378
      peterlaursen
      Participant

      I understand you want to copy 'DATA ONLY' and not 'STRUCTURE and DATA'

      You can export/dump data and import to the other.  In the export dialogue do not choose any DROP option and do not include the USE statement.  

    • February 7, 2007 at 8:01 am #23379
      Tayuke
      Member

      O.k…but where's the import feature? I can't find it…I see the Import from CSV, but other than that, I see nothing. 🙁

    • February 7, 2007 at 8:39 am #23380
      peterlaursen
      Participant

      in the menu .. tools .. restore from SQL dump.

      If there is no USE statement in the SQL you just select a database from the dropdown before importing, and it will be imported to this one.

    • February 7, 2007 at 7:39 pm #23381
      Tayuke
      Member

      Thank You so much 😀 I had to play around with it for a bit, before I got rid of all he error, but its worked 😀 I had to export, then reimport both the old data and new structure info.

      Thanks for your help. You've svaed me alot of time…now, and in the future 😉

  • Author
    Posts
Viewing 3 reply threads
  • You must be logged in to reply to this topic.