how to import .sql file to database, to big for phpmyadmin, no ssh

How can I import a .sql file to a database, the file is to big for phpmyadmin, I dont have ssh on the server.


Thanks, t.

 

Are you importing it to a shared host?

 

Right now, uploading a 95mb database via phpadmin.
Will take some time, but hopefully it will all go in.

If there is another better, easier way, I would like to know also.

 

if phpadmin fails,
use this http://www.mysqldumper.de/en/

 

Thanks, looks good, I will try that.
(shared host, yes)

 

or try bigdump, although to be honest iv never had much success with that either. Iv found the easiest way is to upload the sql file to the server and than get the host to run the dump, they can do it in seconds.

 

I usually upload the sql file to my server then use the absolute path as the location of the file to be "uploaded" by phpmyadmin

 

Bigdump didnt work. couldnt import my file, it was in a format bigdump couldnt handle.

"I usually upload the sql file to my server then use the absolute path as the location of the file to be "uploaded" by phpmyadmin"

I am so new to this, I tried this. you are talking about to put the absolute path beside the "browse" button right, instead of browsing ?

 

Ok, thanks I used mysqldumper.
Now I have another problem getting error:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near" ''at line 1

Anybody have a clue ? Thanks.

 

Line 1? Are you using compatible versions? I mean, have you dumped from a more recent version than the one the hoster has, and /or, have you checked the character set?
Just some clues, not sure...

 

Oh, it should be: (with one ", not two)

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1


Hm, I dont know. i got this whole site content incl. a database (.sql file) for free and just want to use it.

How do I check the character set ?

Its my first time to try sql at all, I am blank. Sorry for so bad info. If you have any idea, please help.

 

tyggemanne, try MySQL Dumper which is my fav as phpmyadmin sux hxxp://www.mysqldumper.de/en/

 

Hi lordliasa. I already used mysqldumper and it was ok.

Now when I try to search in the database, i get :

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1

Do you know what it could be ?

 

It means that your query is wrong. what query are you using to search the database?

 

I am sorry, i am so new with this. I dont know what you mean with a query.

 

query is nothin but the command what you run for the mysql

 

Thought it might be something like that, is this telling you something ?

function browseNames($data, $page)
{
if ( ! $page )
{
$page = 1;
}
global $num_results, $url_prefix;
$output = "<div id='contentColumn'>
<div id='innerContentColumn'>";
$SQL = "SELECT COUNT(*) FROM lyrics WHERE Artist LIKE '$data%'";
$sth = mysql_query($SQL) or die(mysql_error());
list( $number_results ) = mysql_fetch_row($sth);
mysql_free_result($sth);
if ( $number_results == 0 )
{
$output .= "<tr><td>We're sorry, there are no names available for the letter $data in our database.</td></tr></table>";
return $output;
}
$SQL = "SELECT DISTINCT(Artist) FROM lyrics WHERE Artist LIKE '$data%' LIMIT $limit_start $num_results";
$sth = mysql_query($SQL) or die(mysql_error());
while ( $row = mysql_fetch_object($sth) )
{
$output .= "
<div><a href='$url_prefix/name/$row->Artist.html'>$row->Artist</a></div>
";
}

 

Why don't you just contact your host who should do it for you if the .sql file is too large.

If your host won't do it - get a new host.

 

if you can mysql in you can call:
mysql -u (username) -p DatabaseName < DatabaseBackup.sql

Navicat has also always given me good results with big SQL dumps.

 

If I am not wrong phpmyadmin can't load file above 5mb (depends on how your hosting provider has set it). Your best bet is to import using command line client (you will need SSH access for it)

Its simple command

source <sql file name with path>

Code (markup):