Database to big?

[fusionhost]

Hey,

Just having a few problems with MySQL at the moment.

My main problem (most important database) when I try to import it, it says

You probably tried to upload too large file

How do I get around this?

Thank you
J

 

[scsi]

Ftp it to the server and inject the sql via ssh.

 

[fusionhost]

How do I do that?

 

[floyd]

How to do what?

use ftp?
use sql?
use ssh?

 

[fusionhost]

to inject the sql via ssh

 

[scsi]

mysql -u username -p databasename < filename.sql

 

[fusionhost]

it says

[admin@server1 domains]$ cd tracklocations.com
[admin@server1 tracklocations.com]$ dir
logs public_ftp public_html stats
[admin@server1 tracklocations.com]$ dir public_html
forum index.html tlforum.sql
[admin@server1 tracklocations.com]$ mysql -u admin -p tlforum < tlforum.sql -bash: tlforum.sql: No such file or directory
[admin@server1 tracklocations.com]$

?

 

[scsi]

So upload the file to the server in that location with that name.

 

[defomaz]

are you sure with your db name?

mysql -u admin -p tlforum < tlforum.sql

there is usually a prefix in front database name

about import export maybe this can help
hxxp://www.mydigitallife.info/2007/07/21/how-to-backup-and-restore-export-and-import-mysql-databases-tutorial/

 

[fusionhost]

[admin@server1 tracklocations.com]$ mysql -u admin -p admin_tlforum < tlforum.sql
-bash: tlforum.sql: No such file or directory

The database is called: tlforum

 

[scsi]

The error is not because the db is wrong name its because the file is not in that folder with that name. Find out where the file tlforum.sql is.

 

[fusionhost]

[admin@server1 tracklocations.com]$ dir public_html
forum index.html tlforum.sql

thats where I inpuuting that command

 

[IcyTexx]

Lol... Enter the public_html first for that command to work.

 

[scsi]

Yeah you have to:

mysql -u admin -p admin_tlforum < ./public_html/tlforum.sql

or

cd public_html
mysql -u admin -p admin_tlforum < tlforum.sql

 

[fusionhost]

Lol... Enter the public_html first for that command to work.

Im in that folder... Smart ass

mysql -u admin -p admin_tlforum < tlforum.sql

Thanks