I just had a server revert, and I'm putting my backup files back into my website, how ever phpMYadmin is not being nice. I have the databse sql file, I import it, and.. it happly tells me it inserts/ect, but.. no database?
I do have a bad feeling about this, does anyone have any answers?
How big is the dump?
Check the size of it and check the max upload size in a phpinfo file
I fixed the problem by commenting out a line that created the database name (for some reason it just didnt). That fixed it, and yes the host does support SSH (since I run the server o.O).
I still don't know why it was an issue that it didn't want to make the database. Oh yes the clump was like 1557 insertions.
Quote from: bostasp on August 16, 2003, 05:59:55 AM
I have to do all my Backup/Restoring of mySQL through a SSH shell, because of my current host putting a 2mb limit on it... causing a nice crash everytime someone decides to try and backup or restore over that ammount.
it's 2MB by default in php settings
Where would I find this setting at? At what kind of effects does having a DB over 3 MB do?
php.ini
and it doesn't affect existing databases.
When I do a mass import, I import no more than 1000 lines at a time, sometimes it takes me an hour to implement a 15 meg database, but it's guaranteed to work better that way.
i used to save every 2500 lines for messages table
joined the other tables in 1 or 2 .sql files
another alternative is to break down the 3MB files to 3 @ 1MB files or something like that then upload one by one
Which is fun, untill your db gets to 110 meg
How do you split up the sql files? Or should I search for a script that will parse the sql file by X number of tables into mysql at a time?
Something like this to split it up?
function splitfile( $infile, $outfile, $maxsize )
{
// open input file
$ifd = fopen( $infile, "r" );
if( !$ifd )
{
// error opening input file
return -1;
}
// first file number is 0
$filenr = 0;
// open first output file
$ofd = fopen( $outfile . $filenr, "w" );
if( !$ofd )
{
// error opening output file
return -1;
}
// increase filenr
$filenr++;
// set size of output file to 0
$size = 0;
// while we can read a line from input file do ...
while( $line = fgets( $ifd, 1000 ) )
{
// append the line to output file
fputs( $ofd, $line );
// add the size of the line
$size = $size + strlen( $line );
// if the size is > maxsize and this is the end of a statement
if( $size > $maxsize && substr( chop($line), -1 ) == ";" )
{
// close output file
fclose( $ofd );
// open next output file
$ofd = fopen( $outfile . $filenr, "w" );
if( !$ofd )
{
return -1;
}
$filenr++;
// the output file has a size of 0 now
$size = 0;
}
}
// close the last output file
fclose( $ofd );
// return the number of output files generated
return $filenr;}
That's one way, the other way is to search for Notepad Plus (http://www.mypeecee.org/rogsoft/ for the hopelessly decadently lazy bum) and download/install that.
Depending on your system, you could open a 250 meg file (I've opened a 350 meg file and made some alterations). SUGGESTION: Do NOT open anything larger than a 100 meg file unless you have a beast of a machine, jacked up with RAM.
hahaha, yep. :)