Importing .sql files into an existing database in phpmyadmin

timekeeper · Posted: Fri Aug 01, 2003 8:07 am Post subject:

I know this sounds stupid but I can't find an option in phpmyadmin to import a .sql file which means I have to resort back to the command line thing which is annoying.

I only have read-write access in one database so I cannot create a database, also, I wanted to import the bookmark tables for phpmyadmin but they didn't work, any ideas?

Thanks,
Timekeeper

chris · Posted: Fri Aug 01, 2003 10:56 am Post subject:

Click on the *database* name in the left frame of phpMyAdmin. You'll get a list of all the tables in the right frame. Click on the "SQL" link in the top horizontal menu in the right frame. Then you will see some fields and one of them has a "Browse" button next to it. Click on "Browse", select the .sql file you want to import and you are done.

Beware long .sql files! The import will break due to time constraints put by most providers:

http://forums.devshed.com/archive/4/2001/07/2/17971

For other solutions, see

http://www.webmasterworld.com/forum88/953.htm

Regards

Chris

gipper · Private Joined: 07 Jul 2004 Posts: 1

I tried this using the Browse button within the SQL area, and hit GO.

Nothing appears to happen except it gives me the message No SQL query!

What am I doing wrong?

flip fantasia · Private Joined: 06 May 2003 Posts: 2

I have tried to load a backed up DB using MySQL. I enter the DB go to the SQL link, browse and find the file and press go.

After a while at the top left corner MySQL writes: "can not read file"

Our server has been down and reformatted, after setting up the site again I have had this problem.

I tried to upgrade from Nuke 6.5 to Nuke 7.4. This did not help The site runs but only partially.

I also tried to load the DB backup directly on the server.

Any ideas please .... I totally don't know how to get around this.

Note - I'm not experienced with MySQL at all.

chris · Posted: Tue Sep 28, 2004 4:23 pm Post subject:

eHangar · Private Joined: 22 Oct 2004 Posts: 3

turtlebrain · Private Joined: 20 Dec 2005 Posts: 1

Trying to load a 70 me SQL import .

having trouble finding instructions on how to split the file..

thank for your help

Evaders99 · President Joined: 29 Jul 2003 Posts: 3077

Use BigDump - its a script that will do everything you want for big SQL files

zlatan24 · Private Joined: 27 Jul 2009 Posts: 2

Some days ago I found in global network next software-mdf recovery tool,tool helped me in diffifcult situation,it was free as far as I know,moreover program can repair data from corrupted databases in the MS SQL Server format (files with the *.mdf extension),supports data extraction via the local area network,can save recovered data as SQL scripts.

jack22 · Private Joined: 27 Oct 2009 Posts: 1

phpMyAdmin can manage a whole MySQL server (needs a super-user) as well as a single database. To accomplish the latter you'll need a properly set up MySQL user who can read/write only the desired database. It's up to you to look up the appropriate part in the MySQL manual.
I have learned about it and ccdp certification through ccie training and have no difficulties in it.

zlatan24 · Private Joined: 27 Jul 2009 Posts: 2

Quick Links
[Home Page ][ Category Listings ][ Forum Listings][ Forum FAQs]
[ HomeDNS - Domains ] [ Nuke Resources ] [ Nuke Skins and Themes ] [ Nuke Sites Link Directory ] [ LearningLinux.com ] [ Nuke Fixes ] [ NukeZone Hosting ] [ Domain Name Database ]