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