Help with Plesk

[cam2]

I need some help from anyone using Plesk 8.0. I am in the process of moving my forum from a shared server to a VPS using the plesk Control Panel. I have read all of the tutorials and documentation and still having issues. I uploaded all of my files fine but am having a hard time uploading the SQL database. Anyone have any insight that would help me out? Thanks in advance.

[bplinson]

How big is your sql file? When I migrated from one server to another I had to break my sql file up in order to make the pieces small enough to ftp up.

[cam2]

It is a 4.5 MB. Says it's under the max size.

[bplinson]

Do you get any kind of error when you ftp it?

[Zachery]

How are you trying to upload it?

[cam2]

I am trying to upload by their browsing function. I am getting an error #1440. I looked it up and everything seems to be working fine. Do I need to convert the file in any way before uploading?

[Zachery]

You should upload the file via ftp and ask your webhost to restore it vvia the mysql command line utility.

[bplinson]

It should not need formating and should be FTPed in ASCII mode.

It would probably work better if you used an ftp client like WS FTP but ftping from your command line is easy also.

Here are some good command line ftp tutorials:

http://www.udel.edu/topics/internet/ftp/ftpdos.html

http://www.nsftools.com/tips/MSFTP.htm

http://www.artsackett.com/grey_papers/ftp/ftp.html

http://www.computerhope.com/software/ftp.htm

[cam2]

Thank you for the info, I will look at it and ask any questions. Look at these server loads I currently have, arent these bad?

Server Load Averages8.75 11.31 10.58 | 7 Users Online (4 members and 3 guests)

[bplinson]

Extreemly. Mine right now are: 0.56 0.45 0.39 | 117 Users Online (67 members and 50 guests)

[cam2]

now it's at 15 with 5 members and 5 guests, what do I do to change this? Is it the shared server problem? Will my new VPS bring this down to where you are?

Here is my site - www.huntingne.com/forum (http://www.huntingne.com/forum)

[cam2]

Now look at the averages

14.03 13.70 13.08 | 4 Users Online (1 members and 3 guests)

[sspt]

Can you show us the 'top' output?
It should show you what is eating your CPU

[cam2]

Sorry, how do I do that?

[sspt]

Sorry, i was thinking you are already inside a VPS...

I've checked how much domains are using your forum IP:

http://whois.domaintools.com/216.185.128.144



Reverse IP

There are 9,649 other sites hosted on this webserver.


Even in a big cluster it seems an abuse :|

[cam2]

Wow, I did not realize that. I am going to be going to the VPS server within the next couple of days. My members are getting very mad at the speed of the site which goes back to my original question of how to get the SQL file uploaded to the plesk database so I can get this thing done. I appreciate your help.