changing max_packet_size on go daddy v dedicated server

Hi,

Im moving servers and trying to import my database into new sql db.

Ive ftp my database.sql to server.

Using ssh ive tried importing using: mysql -uusername -p datbasename </home/domain/public_html/database.sql

I get max_allowed_ packet error. I know the fix is here but am confused how to change this using ssh on go daddy v dedicated server.

I have tried mysql -uusername -p to go into sql mode and then tried entering the commands as stated in the link but i get nothing just a new line. I'm sure its something v simple.

My server is linux

Can anyone help?

[rogersnm]

I normally just run:
nano /etc/my.cnf
and then reboot MySQL.

[justitaly.eu]

Hi roger,

Sorry im new to v dedicated been on shared hosting. Where do i type nano /etc/my.cnf in the ssh window?

[rogersnm]

where you type everything else XD. I'm new as well, I only got my dedicated server 2 weeks ago. Zero Tolerance referred me to Putty which is what I use now: http://www.chiark.greenend.org.uk/~s.../download.html

[justitaly.eu]

Hey Thanks alot for that, Much better than that tiny screen in the vd server control panel. ill give it go now.

hi,

In regards to my previous quieries.

I have two questions.

1) What do i type in putty to restart my sql server

2) How do i change the max_allowed_packet in the server as i know how to in mysql. I looked on the site listed above but it didn't work.

They say type msqld --max_allowed_packet=16m but do i need to include a path or something?

Sorry for the silly questions, just new at all this and trying to get this to work.

many thanks in advance to anyone that can help

regards

[rogersnm]

1) I use WHM and just reboot the MySQL process.
2) Just type "nano /etc/my.cnf" and then that should open a file. After that you just need to add the line: max_allowed_packets=123M and then press ctrl+X and then press Y and then press enter.

Of course changing 123 to the size you want it to be..

[justitaly.eu]

when i type nano etc/my.cnf i get an error messge "-bash: -bash : : command not found.

I think there must be a problem with my access. On the virtual dedicated server you are supposed to have root access but not the root username. Are you on a virtual or dedicated server?

the file etc/my.cnf is there when i look in the manage files option from my control panel but its not via ssh.

I really thank you for your help. Could this be a problem with my user status?

[rogersnm]

I also have a VPS. Try "locate my.cnf".

[justitaly.eu]

tried that and got:

warning: locate: could not open database: /var/lib/slocate/slocate.db: No such file or directory
warning: You need to run the 'updatedb' command (as root) to create the database.
Please edit /etc/updatedb.conf to enable the daily cron job.
[user@my ip ~]$ -uroot -p updatedb
-bash: -uroot: command not found
[user@my ip ~]$ updatedb
fatal error: updatedb: You are not authorized to create a default slocate database!

I have sent a ticket to go daddy as im sure there is something wrong here.

ok, just an update.

the reason why i have have had no success is

1) i was not logging in as root. to have root access on the v dedicated server you must log in as normal via ssh and then type su and enter same password.

2) i dont have nano installed on my server so thats why the nano command does not work.

At this point is there any other programs that i should install on my server? do i really need nano oris there another way of getting the job done.

just off to do a search for the nano program.