1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
| <p>!/usr/local/bin/php
<?php
mysql_connect('localhost','root','mdp') or die("Connection impossible");
mysql_select_db("ma_base")
or die("Connection impossible a la base de données");
$filename="ma_sauvegarde.sql";
function mysql_import_file($filename, &$errmsg)
{
$healthy = array("€","—","’","¢","“","”","ù","ç","é","è","à","É","â"," ","ô","î","æ","œ","–","´");
$yummy = array("€","—","’","%","“","”","ù","ç","é","è","à","É","â"," ","ô","î","æ","œ","–","'");
// lecture du fichier
echo "1-lecture du chier<br/>";
$lines = file($filename);
if(!$lines) {
$errmsg = "cannot open file $filename";
return false;
}
$scriptfile = false;
/* Get rid of the comments and form one jumbo line */
foreach($lines as $line) {
$line=str_replace($healthy, $yummy, $line);
echo "2-requete sur chaque ligne".$line."<br/>";
$line = trim($line);
if(!ereg('^--', $line)) {
$scriptfile.=" ".$line;
}
}
if(!$scriptfile) {
$errmsg = "no text found in $filename";
return false;
}
/* Split the jumbo line into smaller lines */
$queries = explode(';', $scriptfile);
echo "3-lecture du fichier<br/>";
/* Run each line as a query */
foreach($queries as $query) {
$query = trim($query);
echo "<strong>4-mise en place</strong> - ".$query."<br/>";
if($query == "") {echo "continue<br/>"; continue; }
if(!mysql_query($query.';'))
{
$errmsg = "query ".$query." failed";
return false;
}
}
// retour true si la fonction reussie ^^
echo "reussi";
return true;
}
mysql_import_file($filename, &$errmsg);
?> |
