<div>
'unzip' your file and then feed the resulting SQL statements into a 'mysql' connection (assuming you have CREATE DATABASE privileges).<br />
<br />
Let's say your ZIP file contains a single file, 'dbscheme.sql'. &nbsp;Extract that out of the ZIP file and then run, on the command line:<br />

<pre><code id="code-8231558">mysql --username=mysql_username -p &lt; dbscheme.sql</code></pre>
And enter your password when prompted. &nbsp;This assumes that you're connecting to MySQL on your localhost, if not, just add '-h hostnmae'.
</div>


<div>
Thanks for that but isn't there a way to do it straight from zip? ie. unzip and import in one statement?
</div>


<div>
Great thanks for your help :)
</div>


<div>
<div class="content wysiwyg-content">
Hello all,<br />
<br />
Please could someone help me with the command I need in Ubuntu 11 CLI for importing a .zip into the mysql?<br />
<br />
The .zip file contains a CREATE DATABSE.<br />
<br />
Cheers
</div>
</div>


Hello all,

Please could someone help me with the command I need in Ubuntu 11 CLI for importing a .zip into the mysql?

The .zip file contains a CREATE DATABSE.

Cheers

&amp;#39;unzip&amp;#39; your file and then feed the resulting SQL statements into a &amp;#39;mysql&amp;#39; connection (assuming you have CREATE DATABASE privileges).

Let&amp;#39;s say your ZIP file contains a single file, &amp;#39;dbscheme.sql&amp;#39;.  Extract that out of the ZIP file and then run, on the command line:

And enter your password when prompted.  This assumes that you&amp;#39;re connecting to MySQL on your localhost, if not, just add &amp;#39;-h hostnmae&amp;#39;.

Thanks for that but isn&amp;#39;t there a way to do it straight from zip? ie. unzip and import in one statement?

mysql import from a .zip on Ubuntu

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.

MySQL Server

Linux is a UNIX-like open source operating system with hundreds of distinct distributions, including: Fedora, openSUSE, Ubuntu, Debian, Slackware, Gentoo, CentOS, and Arch Linux. Linux is generally associated with web and database servers, but has become popular in many niche industries and applications.