SpellsBook

 +PHP
+ Adobe Flash 2 0 (0)
+ Arrays (4)
+ COM for Windows (2)
+ Image (2)
+ LDAP (3)
+ MySQL (11)
+ Basic MySQL Example
+ Database Information
+ Error Checking
+ Fetch Associative Array
+ Last Insert ID
+ Mysql PROD function
+ Number of Rows
+ SQL Dump to Database
+ Select Examples
+ Table and Field Information
+ Various Information
+ Regular Expressions (2)
+ String Manipulation (12)
+ Time and Date (6)
 +Snippet Options
+   Printer Friendly
 +Library Options
+   View Other Library
Adobe_Flash_3_0
C_Plus_Plus
Debian_Install
Del_me_Soon
HTML_and_CSS
JavaScript
Linux_Commands
PHP
 +General Options
+   Library Home
+   PHP-CSL Credits
+   PHP-CSL License
+   Resource Links
+   Log in
Syntax for: MySQL / SQL Dump to Database

1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21:
22:
23:
24:

<?php 

// open the .sql file 
$fp = @fopen("mysql.sql""r"); 
$file fread($fp80000); 
fclose($fp); 

$lines explode(';',  $file); // split the .sql into sepearte queries 
$cnt count($lines); // count array elements 

// database connection string 
mysql_connect("localhost","root"); 

// loop each query and execute 
for($j=0; ($j<$cnt-1); $j++) { 
    if(!
mysql_query($lines[$j])) { 
            
// echo any errors 
            
echo "Error on line $j of Query:<br>"
            echo 
$lines[$j]."<br><Br>"
            die; 
    } 

// show confirmation 
echo "Done"
?> 
 
Description for: MySQL / SQL Dump to Database
  If you wish to execute many queries stored in a .sql file (usually created with a MySQL Dump) - this simple script will open the file and execute each query.


 
Powered by: PHP-CSL V0.9