Phpmyadmin method to import large amounts of data in SQL statement format
- 2020-03-31 20:47:30
- OfStack
The contents of SQL. PHP file are as follows:
Where root represents the database user name, mypassword represents the password of root, database represents the name of the database to be imported, and a.sql represents the file name of the database file
<?
system("mysql -uroot -pmypassword database < a.sql");
print "sql ok";
?>
Where root represents the database user name, mypassword represents the password of root, database represents the name of the database to be imported, and a.sql represents the file name of the database file