Databases
StackOverflow2013
Postsdbo
POLooking for a MySQL query command to insert all the queries in local .sql file to the MySQL database on a remote server
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POLooking for a MySQL query command to insert all the queries in local .sql file to the MySQL database on a remote server
    primarykey
    data
    text
    <p>Is there a MySQL query command to upload/insert all the queries in a .sql file (generated from mysqldump) on a local server to a mysql database on a remote server?</p> <p>I'd like to try and do this all within MySQL queries from within an application and avoid issuing command-line mysql commands because I think that there would be a bit more overhead in parsing the output in that way.</p> <p>I'm looking for something like, e.g. in Perl:</p> <pre><code>my $hostname = "remote_server_address"; my $dsn = "DBI:mysql:dbname:$hostname"; my $user = "user"; my $password = "password"; my $dbh= DBI-&gt;connect($remote)dsn, $user, $pw) ); my $myquery = "SPECIAL_INSERT_QUERYCOMMAND my_local_mysql_query_file.sql"; my $execute = $dbh-&gt;prepare($myquery); $execute-&gt;execute; </code></pre> <p><strong>Update:</strong> Additional requirements: Is there any "flow-control and resilience" whereby any connection issues between the local and remote server are handled so that the entire set of queries get transfered. And would there be a limit to the size of the file to be transferred? (I hope not).</p>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTQuestion
    1. UStherobyouknow
    1. UStherobyouknow
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. This table or related slice is empty.
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload