[BlueOnyx:20483] Re: MySQL Import

[Richard Sidlin]

Hi Sean - Thanks, that's excellent.

 

 

You can use SSH Richard.

 

Upload the file, then import using this

 

mysql -u your_user -p your_database < dump_file.sql

 

So for example, if I upload my sql file to /home/sqlfiles

The username on the DB is "SQLUSR", Password of "123456" & the Database name
is "SQLFILES"

 

Cd /home/sqlfiles

mysql -u SQLUSR -p SQLFILES <sqlfiles.sql

-hitting enter SHOULD prompt for a password. enter it and hit enter again-

 

 

Or if your not much for SSH, just increase phpMyAdmin's limits.

Modify php.ini and that should allow you to upload :)

 

From: Blueonyx [mailto:blueonyx-bounces at mail.blueonyx.it] On Behalf Of
Richard Sidlin
Sent: Monday, January 09, 2017 3:35 PM
To: 'BlueOnyx General Mailing List' <blueonyx at mail.blueonyx.it
<mailto:blueonyx at mail.blueonyx.it> >
Subject: [BlueOnyx:20481] MySQL Import

 

Guys

 

If I need to import a MySQL database larger than 8,192Kib, the limit that
phpMyAdmin is telling me, how to please?

 

Thanks

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.blueonyx.it/pipermail/blueonyx/attachments/20170109/027d7ceb/attachment.html>