[MontanaBighorn]

according to what im reading in the help file i need to insert the script using the above pictured command.

but when i click on the table and then attempt to use the “insert from CSV” command its faded out and wont let me select it as an option. any idea?

thanks,

[MontanaBighorn]

peterlaursen wrote on May 12 2007, 05:41 AM:

To import with SQLyog you should start creating an empty database (right click in 'Obkject Browser (the left window) … create database) and select this one before running the SQL script!  If no databse is selcted you will get the error 'no database selected' (how logical can the world be? 🙂 )

i dont really understand where the script comes in.

i create the new database.

it asks for a name of the new database.

it creates the database.

….but nowhere in that process does it ask me to insert the sql script. i guess im clueless about how to run the script or where to insert it, and i really do appreciate the effort youre taking to explain it to me. thank you again.

Quote:

2) Your script will import on every MySQL version.  tTere are no ENGINE or CHARSET specification in the file that are specific for some MySQL versions only.  Seems like you exported from MySQL 4.0 or lower.

its downloaded from the website where i downloaded the forum software.

[MontanaBighorn]

peterlaursen wrote on May 11 2007, 02:08 AM:

2)  If ther is no CREATE DATABASE and USE statement in the file you will need to start creating it manually and selecting it.

i also dont know what any of that means. i stuck a copy of the script at http://UtilityOffRoad.com/1.txt if youd care to take a peek at it.

thanks again,

[MontanaBighorn]

thank you for the reply sir. however, under the current version i do not see an option for “import”. also, under “table” there is “paste sql statements” but after i mouse over that the options arent highlighted. please explain, and thanks a bunch.

[Author]

Posts