MySQL DB transfer

[cntbill]

Forgive me if this has been asked before, I tried search but I don't seem to have the rights to do a search.

I have an osCommerce site that I am thinking of moving to Host Gator, I think I understand all the DNS, FTP, stuff but, it is the database move that I am worried about.

Number one I am not completely sure on how to move it, I'll have to review the info on osc's site I guess, but looking here to see if there was any suggestions as to the best procedure to do so.

Number two, then will I have to give the db a new name here and if so suggestions to how I can make this move as painless as possible.

In reality I would like to just start from scratch but I don't have the luxury to dedicate the amount of time it would need, because if I remember right the first time I set up OSC it took me quite a bit of time searching the forums to find all the information I needed. Also the other thing is my site was set up for php 4 and my host changed to php 5 which is good but I didn't know about the change until a customer sent me an email complaining about an order.... however I did manage to patch the php files to get it to work with php 5 now.

So is there any good guidelines to follow? Like I am guessing move/copy my sql over first, etc.

Thanks,

Bill...

[GvilleRick]

Does your old host use cPanel? If so, you could just ask support to move the whole account by filling out the form here.

[cntbill]

Originally Posted by GvilleRick

Does your old host use cPanel? If so, you could just ask support to move the whole account by filling out the form here.

Thanks for the suggestion, but sorry no, they have their own proprietary control panel, but I believe I can access the db through PHP MyAdmin. As I was just wondering if anyone know of a simple procedure or has been through the steps and could enlighten me what I am up against.

[Txspaderz]

If you have SSH access to your databases, log in and run the following command:

mysqldump databasename > backup.sql

Than upload that sql file to your space and HostGator Admins can restore it quickly for you.



You can backup via phpMyAdmin in the Export section of the facility. Just like the backup facility in cPanel, it can give backups to you as a .tar.gz format which means you’ll be able to restore it via the cPanel facility if you need to do so.
• Once you’ve accessed the phpMyAdmin facility go into the database (empty or otherwise) and from the top menu click Export.
• Scroll down on that page until you get to a ‘Save as file’ option and select ‘gzipped’ and leave the settings as default.
• Click ‘Go’

[cntbill]

Ok.. I kind of get that.

So it don't matter what the name is, and it is possible to use the same name here on Host Gator? As this would help me avoid editing the OSC php files.

[gwyneth]

Unless your old host has the same naming convention for databases as cpanel (username_database; username_databaseuser) you're going to have to change something.

While HG doesn't guarantee non-cPanel host transfers, I think they usually try--in any case, it's worth writing sales and describing your situation in detail (including the old host name) and see what they say.

[cntbill]

Thanks for the replies.

I found out... remembered that osCommerce has a backup and restore feature. So I imagine that I could just do a backup, setup my site with OSC here with a sample DB, then rename the backup file to the naming convention that Host Gator use's, and then do a restore. Sound like a plan?

[lsuedulive]

This was a good answer. Too bad HG does not have its tech support to write short articles like this to add to help files, FAQ or the KB. I see now there is no use buying from HG or a new user like me will never get a Guestbook or Forum installed.

Originally Posted by Txspaderz

If you have SSH access to your databases, log in and run the following command:

mysqldump databasename > backup.sql

Than upload that sql file to your space and HostGator Admins can restore it quickly for you

[GvilleRick]

Originally Posted by lsuedulive

This was a good answer. Too bad HG does not have its tech support to write short articles like this to add to help files, FAQ or the KB. I see now there is no use buying from HG or a new user like me will never get a Guestbook or Forum installed.

Comments like these always amaze me. HG provides great tools to develop a website but tools require that the user take some responsibility to learn how to use them. Fantastico is included on all accounts and it takes a couple of clicks to install a Guestbook or Forum. While I might think it is better to install the script manually (which is why I don't have Fantastico installed on my dedicated) it is there for those that want it.

There are way too many scripts available for HG (or any host) to be expected to provide support. Most of the major scripts have their own support available either free or for pay. HG often goes out of the way to offer help even with scripting problems and there are many users in these forums that spend many hours helping new users (and old users) when they have problems. Best of luck finding a host that will meet your expectations.

[lsuedulive]

I did not realize you worked for HD. My comment was not about HD and their scripts. It was about your inability to find the info you were looking for in a search or FAQ or KB.

I thought you answered very fast to just be surfing webhosting packages.

Originally Posted by GvilleRick

Comments like these always amaze me. HG provides great tools to develop a website but tools require that the user take some responsibility to learn how to use them

[gwyneth]

Originally Posted by lsuedulive

This was a good answer. Too bad HG does not have its tech support to write short articles like this to add to help files, FAQ or the KB. I see now there is no use buying from HG or a new user like me will never get a Guestbook or Forum installed.

In addition to Rick's comment, this forum also has 12 other categories that are not public, that provide an enormous amount of help about every aspect of setting up and operating a site.

[lsuedulive]

All or most of HG is located or run out of the UK or Austrailia?

[Keith W]

Nope.


USA

[gwyneth]

Originally Posted by lsuedulive

I did not realize you worked for HD. My comment was not about HD and their scripts. It was about your inability to find the info you were looking for in a search or FAQ or KB.

I thought you answered very fast to just be surfing webhosting packages.

Rick doesn't work for Host Gator (or whatever "HD" is). This is a peer support forum, where people who have HG hosting accounts try to help others. Once people start hosting at HG, they can see the other forum categories where there is extensive information and people like Rick go to some trouble to answer questions.

You're really being too cynical about this, IMO.

[lsuedulive]

Originally Posted by gwyneth

You're really being too cynical about this, IMO.

In my opinion cntbill was asking for INFO.

In my opinion LSUEDU LIVE was stating it would be better if the info was in a FAQ or help file rather than go to a forum and ask a question.

In my opinion Asheville was way off topic talking about HG's scripts and not the subject of *finding info in a FAQ instead of a forum*

In my opinion gwyneth is employed or well connected to HG to skip the subject entirely of, *Having the info in a FAQ that can be searched by a client faster then logging onto a forum and asking questions*

In my opinion Bill Gates got rich with his FAQ, help files, etc.

[lsuedulive]

Originally Posted by gwyneth

You're really being too cynical about this, IMO.

I will try to post to you everytime in the future, HD instead of HG. I am in a hurry and not in a typing test.

I have nothing against HG and their help , support, owners. I was stating a broad fact that works on every hosting company or any cmpany of any type that is related to the Net.

If fact I am giving them a 29 day test right now to research their help and FAQ, etc;

http://www.melvillehighschool.org/

[gwyneth]

Originally Posted by lsuedulive

I did not realize you worked for HD. My comment was not about HD and their scripts. It was about your inability to find the info you were looking for in a search or FAQ or KB.

Originally Posted by lsuedulive

was stating it would be better if the info was in a FAQ or help file rather than go to a forum and ask a question.

... instead of a forum

...onto a forum and asking questions

It would have been easier for us to deduce your meaning if you had included it in your first post.

[lsuedulive]

Originally Posted by gwyneth

It would have been easier for us to deduce your meaning if you had included it in your first post.

What ever floats your boat honey, go for it. (IMO)

Go Tigers and go HD

[Keith W]

You should really try searching round the Hostgator web site a bit more, they have extensive help files and tutorials.


As for the OP, bottom of this page: http://www.hostgator.com/tutorials.shtml

[Keith W]

Originally Posted by lsuedulive

What ever floats your boat honey, go for it. (IMO)

Go Tigers and go HD

Just to add I would drop the smart ass comments and attitude if I were you, especially if you intend to hang round this forum.

Show some respect

[lsuedulive]

Originally Posted by Keith W

Just to add I would drop the smart ass comments and attitude if I were you, especially if you intend to hang round this forum. Show some respect

You may as well give up now. I have never found my help in a forum. Never will. She and you do not know what HD meant.

You may as well give up and stick with Ms England cause I will never spend my time on a forum if the KB, FAQ does not have what I need.

Go HD...all dogs go to heaven...

[striddy]

Originally Posted by lsuedulive

You may as well give up now. I have never found my help in a forum. Never will. She and you do not know what HD meant.

You may as well give up and stick with Ms England cause I will never spend my time on a forum if the KB, FAQ does not have what I need.

This is a pre-sales questions section of this forum. Do you have any valid questions you wish to have answered? Or are you just here wasting your time?

[Keith W]

Originally Posted by lsuedulive

You may as well give up now. I have never found my help in a forum. Never will. She and you do not know what HD meant.

You may as well give up and stick with Ms England cause I will never spend my time on a forum if the KB, FAQ does not have what I need.

Go HD...all dogs go to heaven...

How old are you, 2?

Now got forth, find your self a corner, stick the middle digit of your right hand where the sun doesn't shine and swivel

[lsuedulive]

Originally Posted by striddy

This is a pre-sales questions section of this forum. Do you have any valid questions you wish to have answered? Or are you just here wasting your time?

As long as folks like you behind your keyboard get up the courage to reply my boy, we shall remain here. So quit now and do not reply to any of my posts. Do not let me tell you again to shut up.

[lsuedulive]

Originally Posted by Keith W

How old are you, 2?

Now got forth, find your self a corner, stick the middle digit of your right hand where the sun doesn't shine and swivel

From behind your keyboard you are really impressive. I met a boy such as you face to face in the Mall and he peed in his pants. Stay behind your keyboard and don't let me read any more replies from you. Everything clear?