phpMyAdmin loaddata

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
eggoz
Forum Commoner
Posts: 43
Joined: Fri Dec 27, 2002 8:51 pm

phpMyAdmin loaddata

Post by eggoz »

My hosting company uses phpMyAdmin to let me host mysql databases. My problem is I am not able to use their page for importing a textfile in a database. They told me to import the text file onto the server and use mysqlimport command. But I don't understand how to use this command since thier is no command line to pass the command through. Can this be done though a webpage? If so, how can this be accomplished? Thanks in advanced.
evilcoder
Forum Contributor
Posts: 345
Joined: Tue Dec 17, 2002 5:37 am
Location: Sydney, Australia

Post by evilcoder »

If you cant dump .sql files then you have to use manual "SQL IMPORT"

when your in the database you want, there will be a link that says

SQL

click that, then there should be a text fied. Just put your SQL commands in there and press ok, or Go, or whatever it is.
Post Reply