MySQL import

Hi folks, I've exported my .sql file from the old database, and I want to import it into the new database.

How do you do it

I can't find an import link, I'm baffled.

Any ideas?

 

Run mysql and use the source command. For example:

# mysql -u root -p database-name
mysql> source ~/filname.sql

J.D.

 

Umm I'm been thick I know J.D but I have zero knowledge of mysql (I shouldn't be let free with technology!)

Where do I run the mysql?

I am using the myphp admin

 

If you are using phpMyAdmin
1. click Sql
2. click browse
3. browse for the sql file on your comupter and ok
4. click go

 

I just downloaded and installed PHPMyAdmin. All of my databases are visible and I can create tables okay, but when I try to do any type of import, I get a "Cannot find server or DNS Error" message.

Other than that, everything appears to function okay. I normally do everything from the command line, but PHPMyAdmin looks like it's easy to use. Are there an additional configuration issues that I may be missing? PHPMyAdmin never asks for a Username or Password.

Any clues as to what might be causing this? The file is about a one meg datafeed text file. All the columns were previously set up in the table.

 

Is phpmyadmin installed locally or on a live/remote server?
Could be that php upload is set for less than 1mb although the default is 2mb