Jump to content

importing dump.sql into database


Guest rocketranger

Recommended Posts

Guest rocketranger

First of all, I want to thank everyone for their patient guidance with a complete web newbie.

I am going through the readme file trying to install CC for the very first time. Remember, I'm doing this with almost ZERO web knowledge.

I uploaded the files and folders from the 'upload' folder. I installed a mySQL database on my server. I went to www..cubecart.com/build and followed the instructions to get the code.

Now, how the heck to I import the dump.sql file into my database? They recomend a program (phpmyadmin), I downloaded it, but have no idea how to set it up and run it. I'm completely lost.

It's frustrating because I follow the steps, but really have no idea what I'm doing. I'm about ready to just hire someonw to set it up for me.

Link to comment
Share on other sites

PhpMyAdmin is a program that is on your web host if they support MySQL and Apache. You would logon to your host and navigate to your database. There should be a link to PhpMyAdmin.

Having said that, if you have uploaded a new installation to your host and go through the installation process, your database will be set up for you. I assume this is a remote installation and not a local one. The only information you need to have on hand is your server name (usually localhost), the name of your database, database user name and password.

If you need help to install, email me and we can make arrangements to meet on MSN or yahoo and get this done for you.

Link to comment
Share on other sites

Guest rocketranger

Thats a very generous offer! I'm going to go look at my host control panel first, and I'll let you know. Thank you.

Nope, there's nothing there. No way to access my database. ;)

Link to comment
Share on other sites

Thats a very generous offer! I'm going to go look at my host control panel first, and I'll let you know. Thank you.

Nope, there's nothing there. No way to access my database. ;)

What we have here is a failure to communicate (from the flm, "Cool Hand Luke").

If you did actually go through the 5 step installation screens of Cube Cart, it is not true that your data base will be created for you. What is true is, your database HAS ALREADY been created for you.

Further, unless you intend some special action in the Db, there is no need to go there at this point. The CC ACP (Admin Control Panel) provides a front end so you can add, edit, remove items wuthout seeing the Db.

So, let's do a sanity check - when you say you intalled CC, do you mean you went to the server, uploaded the files to a directory and then went to:

www.yourdomain.com/install -

and went fromstep 1 through 5?

Link to comment
Share on other sites

Guest rocketranger

Arghhh!

I realized I followed the manual instructions rather than the auto.

But I did everything as stated and it won't show up.

This is what I get:

Warning: session_start(): open(/tmp/php-ses/sess_a4f263bf5b9db63572a211c2bd6050ab, O_RDWR) failed: Permission denied (13) in /nfs/cust/5/21/88/588125/web/shop/install/index.php on line 30

Warning: session_start(): Cannot send session cookie - headers already sent by (output started at /nfs/cust/5/21/88/588125/web/shop/install/index.php:30) in /nfs/cust/5/21/88/588125/web/shop/install/index.php on line 30

Warning: session_start(): Cannot send session cache limiter - headers already sent (output started at /nfs/cust/5/21/88/588125/web/shop/install/index.php:30) in /nfs/cust/5/21/88/588125/web/shop/install/index.php on line 30

Warning: Cannot modify header information - headers already sent by (output started at /nfs/cust/5/21/88/588125/web/shop/install/index.php:30) in /nfs/cust/5/21/88/588125/web/shop/install/index.php on line 40

Warning: Unknown(): open(/tmp/php-ses/sess_a4f263bf5b9db63572a211c2bd6050ab, O_RDWR) failed: Permission denied (13) in Unknown on line 0

Warning: Unknown(): Failed to write session data (files). Please verify that the current setting of session.save_path is correct (/tmp/php-ses) in Unknown on line 0

Link to comment
Share on other sites

Jerseyjoe, I did not say that the database would be created. What I said was that it would be set up. I agree and let's get sanity back and read before posting.

Rocketranger have you set your permissions (CHMOD) correctly?

Link to comment
Share on other sites

I did not say that the database would be created. What I said was that it would be set up. I agree and let's get sanity back and read before posting.
Roban, I think you are taking offense where none is intended. If I offended you, I apologise. I was trying to get to the heart of the problem as it stands - which is that we still really do not know where he is in the innstallation process.

Saying, "I did everything as stated and it won't show up" tells us nothing useful. I know he's trying to help us help him but we still don't have the right details to find the cause of the problem. As I said, so far it's a communication problem, not an installation problem.

to rocketranger - both Roban and I are trying to help you.

Let's start with the basics.

Rocketranger, you said:

QUOTE

"I went to www..cubecart.com/build and followed the instructions to get the code."

END QUOTE

I don't know what codes you would have gotten from that address. And it doesn't matter. Here's what we need to know:

Did you go to "www.yourdomain.com/install" ?

If you did, you should expect to see Step One of the Cube Cart installation process.

If you did not go to "www.yourdomain.com/install" please do so now and tell us what you see.

you also say:

QUOTE

Now, how the heck to I import the dump.sql file into my database? They recomend a program (phpmyadmin), I downloaded it, but have no idea how to set it up and run it. I'm completely lost.

END QUOTE

As I said earlier, you do not have to dump or doing anyhting else in order to finish your installation.

If you already have created the Db in the Control Panel provided by your host, you will use its setup information (database name, database user, and database password) in Step 3 of the CC 5 Step installation process.

So we are stuck at the question, did you go to "www.yourdomain.com/install"

Let's take it from there, OK?

Again Roban, I apologise if I offended you.

Link to comment
Share on other sites

Yes. I did. I posted the error I get above.
Seeing something other than Step One of the five step installation screens suggests strongly that the upload is corrupt.

In that case, the simplest thing to do is delete the uploaded files from the server and do a fresh uplaod. You even may as well first go get a fresh download from CC, just to eliminate that as an issue.

BTW, which control panel does your host provide?

Link to comment
Share on other sites

Guest rocketranger

Just did a fresh upload. Here's what I get when I go to http://www.rocketranger.com/shop/install

Warning: session_start(): open(/tmp/php-ses/sess_b4bbcb3c7c3e5721217dc1593b90ba79, O_RDWR) failed: Permission denied (13) in /nfs/cust/5/21/88/588125/web/shop/install/index.php on line 30

Warning: session_start(): Cannot send session cookie - headers already sent by (output started at /nfs/cust/5/21/88/588125/web/shop/install/index.php:30) in /nfs/cust/5/21/88/588125/web/shop/install/index.php on line 30

Warning: session_start(): Cannot send session cache limiter - headers already sent (output started at /nfs/cust/5/21/88/588125/web/shop/install/index.php:30) in /nfs/cust/5/21/88/588125/web/shop/install/index.php on line 30

Warning: Cannot modify header information - headers already sent by (output started at /nfs/cust/5/21/88/588125/web/shop/install/index.php:30) in /nfs/cust/5/21/88/588125/web/shop/install/index.php on line 40

Warning: Unknown(): open(/tmp/php-ses/sess_b4bbcb3c7c3e5721217dc1593b90ba79, O_RDWR) failed: Permission denied (13) in Unknown on line 0

Warning: Unknown(): Failed to write session data (files). Please verify that the current setting of session.save_path is correct (/tmp/php-ses) in Unknown on line 0

What do you mean by 'what control panel does your host provide?'

Link to comment
Share on other sites

Guest rocketranger

What do you mean by 'what control panel does your host provide?'

Your hosting service normally would provide you with a Control Panel that lets you manage your web site.

Who is your host?

gate.com

Link to comment
Share on other sites

What do you mean by 'what control panel does your host provide?'

Your hosting service normally would provide you with a Control Panel that lets you manage your web site.

Who is your host?

gate.com

Which hosting platform are you using? They offer Unix or Windows?
Link to comment
Share on other sites

windows

BINGO - There's your problem.

Shopping Carts like Cube Cart are designed to work on Unix servers, not Windows. They are two different universes. Human (Unix) and Klingon (Windows).

You want a host that will provide you a Unix server, preferably one running Red Hat Apache, and that includes a CPanel (the best control panel you find for managing your site.).

There are many choices. You can pay a little - and get a lot of useful services, or you can pay a lot and get few services at all. You just have to shop.

Don't be fooled by huge footprints and humongous bandwidths. Those are the empty calories of the hosting business. It is highly unlikely that you will need even 1 gig of space and, unless you are running a porn shop or peddling illegal music and movies, you'll never come close to using 10% of the promised bandwidth.

Look for a host who offer a full range of services. Be sure he has a track record and some serious business. Nothing is worse than waking up one day and discovering that your web host has shut down and disappeared. Happens every day. I just acquired a new client today who told me when her host stopped answering emails she went to his address and was told that no one has been him since the cops took him away.

Because he did the scummy thing of registering her domain name with himself as registrant she lost not only her web site, her store, her ordering history, her list of customers, her links and her Google page rank, she had to register a new name and start all over again. Fortunately I was able to find her old pages in Archive.org so we at least salvaged her product descriptions and some images.

So choose carefully on more than price and un-needed server space or bandwidth. Make sure you get money-back guarantees and 24/7 tech support that actually works. Be wary of hosting outside major countries. Stick with England, Germany, USA, Canada, Sweden.

There are many here who will suggest a good hosting service that they can speak well of. I own one but it would not be proper for me to say its name here in these forums because there is a sound and reasonable purpose in keeping the forums free of bias and commercialism.

Once you have that kind of service, install CC on the server and installation will go smoothly. If you have problems, we'll all help you.

Regards.

Link to comment
Share on other sites

Guest rocketranger

AHHHHHHHHH!!!!!

I just called my hosting company. I was wrong. I am on a Unix server.

I was really hoping to be able to figure this out myself. But I think I'm ready to pay somone to install. I've followed the directions multiple times now and nothing is working.

Any other ideas? Don't let me give up!

Link to comment
Share on other sites

AHHHHHHHHH!!!!!

I just called my hosting company. I was wrong. I am on a Unix server.

I was really hoping to be able to figure this out myself. But I think I'm ready to pay somone to install. I've followed the directions multiple times now and nothing is working.

Any other ideas? Don't let me give up!

Send me the following in a Private Message (clcik on the PM tab at the lower left of any of my messages):

your web site address

the address for your control panel

your user name

your password

I will go and look at your MySQL setup.

I'm on my way out the door but will be back around 1pm. It's shortly after 9am right now.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...