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?

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

Hi roger,

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

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

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

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..

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?

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

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.