Please Login or Register

Can't run Load Data INFILE/OUTFILE?

There are a few mysql queries that we don't allow customers to use with their main account user(or any user for that matter). One of these commands is CREATE database. The only user that can create databases on our systems is the mysql root user, and the only way to use its priveleges to create a new database is through the cpanel, under 'Mysql Databases'. We also don't allow either commands for LOAD DATA INFILE/OUTFILE, for security reasons. There are some alternatives to this, if you're trying to import or export a database. Here's two examples:

LOAD DATA INFILE ALTERNATIVE FROM SSH:
$ echo "source databasefile.sql" | mysql -u user -ppassword databasename

LOAD DATA OUTFILE ALTERNATIVE FROM SSH:
$ mysql -u user -ppassword databasename > outputfile.sql

Was this answer helpful?

Add to Favourites Add to Favourites

Print this Article Print this Article
Also Read
How do I import a Database(PhpMyAdmin) from an .sql file? (New php MyAdmin version) (Views: 810)
How do I import a Database(PhpMyAdmin) from an .sql file? (Views: 6801)
What version of MySQL are you running? (Views: 5708)
How do I import a Database(Command Line) (Views: 7750)
Users having problems connecting to mysql database using SSH and/or putty/other client. (Views: 1893)

awards_sum