How To Import SQL?

[Titan85]

I have been trying to learn some php and a lot of the tutorials say to import some lines to the SQL tables via phpmyadmin. For example, import this code into a MySQL table:
Create TABLE `stats` (
`ID` tinyint(11) NOT NULL AUTO_INCREMENT,
`IP` varchar(18) NOT NULL,
`referer` varchar(255) NOT NULL,
`time` varchar(30) NOT NULL,
`date` varchar(30) NOT NULL,
PRIMARY KEY(`ID`))
TYPE = MyISAM;

I know how to get into phpmyadmin and all that, but where do i go in order to import lines?

[Twey]

This code is the output of a tool called mysqldump. This tool generates the SQL necessary to create a table. You can just execute it under the "SQL" tab in phpMyAdmin like any other query.

However, I suggest dropping phpMyAdmin in favour of the default command-line client. You'll get a much better feel for the language.

[Titan85]

This code is the output of a tool called mysqldump. This tool generates the SQL necessary to create a table. You can just execute it under the "SQL" tab in phpMyAdmin like any other query.

However, I suggest dropping phpMyAdmin in favour of the default command-line client. You'll get a much better feel for the language.

Thanks, looked at it and there it was, plain and simple to see if you know what your lookin for . What do you mean by default command-line client?

[Twey]

When you install the MySQL server, a client is installed too, called simply mysql. This should be run from a command-line (mysql -p -u <yourusername> -h <host>) and you can then modify your database by executing MySQL queries in real-time.

[BLiZZaRD]

Hijacking this thread...

I am using putty for most of my sqldumps. I am using this code:

mysqldump --allow-keywords --opt -u<username> -p<pass> <user_dbname> > /path/to/dump/to/<name of file>.sql

It works perfect everytime.

BUT! I was wondering 2 things:

1) is it possible to get a gzip.sql and if so what do I change?

2) what does --allow-keywords --opt mean?

[Twey]

1) is it possible to get a gzip.sql and if so what do I change?

Not directly, no. Chain it with the gzip command:

mysqldump --allow-keywords --opt -u<username> -p<pass> <user_dbname>|gzip > /path/to/dump/to/<name of file>.sql.gz

2) what does --allow-keywords --opt mean?

Read the manpages

     --opt

          This option is shorthand; it is the same as specifying
          --add-drop-table --add-locks --create-options --disable-keys
          --extended-insert --lock-tables --quick --set-charset. It should
          give you a fast dump operation and produce a dump file that can be
          reloaded into a MySQL server quickly.

     --allow-keywords

          Allow creation of column names that are keywords. This works by
          prefixing each column name with the table name.

[Titan85]

Thanks for the help. I'll have a look at simply mysql

[Twey]

No no. I mean it's simply called "mysql", not that it's called "simply mysql"
I apologise for resulting confusion.

[BLiZZaRD]

Thanks Twey... I will read the "manpages" when my wife and kids aren't around

[Twey]

In the bsd-games package on Gentoo, there's a rather obscure program called "sex." I recommend it to everyone just so I can have the joy of telling them what to type when they ask how to use it.