My MYsql dilemma when hopping servers

[one1]

Hi guys! Let me give you some info and see if you may can help.

Hosting on the willow server (linux) through siteflip.com and using CpanelXpress.

Installed zen cart successfully.

Attempting to import the Zen site from the old site. (Doing this for a buddy).

*#1- My problem is that I cannot seem to get the MYsql to upload. It doesn't seem to want to take this 2.3MB file.

*#2- When I try to use the FAQ directions to import a site, problem #1 arises after I "drop" and attempt to import in the next step leaving me with a white page and SQL database not found error. I cannot get this SQL file to upload to save my life.

*#3- Can someone direct me to another way to get this SQL database that has been saved into the server and make it work perhaps? There is a lot of details in the store (1500 items) that are going to be to much to redo one by one. It looks like an executable file, but it shouldn't be.... how do you think it was saved??

Below are the folders I was given for the transfer from the guy.








OK, you see in picture #2 the sql file is an executable file, it should look like this instead so I am wondering how it was saved which is holding me back from uploading it. Below is how it SHOULD look to me (not an executable). This is the backup of the stock SQl database.

[one1]

This is the error I get after "Drop" as stated in the FAQ and moving on to import as I attempt to upload the sql, after a few minutes i refresh the zen cart main front page on the site and just keep getting this:

[one1]

This SQL he gave me simply will not upload at all, not even try it just stalls out. Any idea why or how to load it?

[DrByte]

I suggest you contact your hosting company about how to use the interface they supply for you to use. I'm not familiar with cPanelExpress or whatever you referred to, but your hosting company should be ... and maybe they even have some FAQs on their website for how to use the tools they offer.

[one1]

35,000 posts and you don't know what Cpanel is? (excuse my surprise, I thought everyone did. I'm going to search the site to see how many times it is mentioned now). With most major hosts using Cpanel server software I don't know how you missed it, but it's an open system. It just seems to be something about this SQL database that isn't uploading.

PS- http://www.cpanel.net/ :)

Thanks for the response!

(Edit: over 300 hits, I'm not crazy )

[DrByte]

Sorry, cPanel vs cPanelExpress ... surely those are different animals?
I did check, and I don't see any reference to "cPanelExpress" in the list of products on the cpanel.net website.
Surely that's not the primary topic of this discussion though.

My point is not figuring out how to use cPanel.
The point is that you probably need some direct one-on-one help with loading a .sql file into the database, and the people whom you are paying for the use of the server you're using they may well be the first people to ask about that.

[DrByte]

Or, lest I sound like I'm being confrontational (which was certainly not my intent), let's tackle this from another angle ...

*#1- My problem is that I cannot seem to get the MYsql to upload. It doesn't seem to want to take this 2.3MB file.

How do you know it's not uploading/importing? Is there a particular error message? The error message should indicate what's wrong if a problem is occurring.
Or, does the "message" come up as "file imported successfully" (or whatever phpMyAdmin says when it successfully handles an imported file)?
If it says it successfully imported, then you probably have the wrong prefix, as indicated in step 2(a) of the FAQ article which I think you were referring to earlier: https://www.zen-cart.com/tutorials/i...hp?article=100
ie: what's the DB_PREFIX from the old site?
And what prefix did you use when you did your install on the new server?
They have to match or you'll not see the data after importing.

*#2- When I try to use the FAQ directions to import a site, problem #1 arises after I "drop" and attempt to import in the next step leaving me with a white page and SQL database not found error. I cannot get this SQL file to upload to save my life.

It's still unclear where the problem is. You said "and attempt to import in the next step leaving me with a white page and SQL database not found error".
1. "where" do you see the white page?
2. "where do you see the "SQL database not found" error?
3. A "white page" and an "error message" don't usually go together. It's usually one or the other.
You need to post more details about what exactly is happening, and when, along with what you expected was to happen and why you expected that.
THAT is why you didn't get a reply when you first posted. In fact, that's exactly why I personally skipped it when I first saw it, and moved on to something else that did have enough information to provide guidance about. I wouldn't be surprised that that's why others also didn't reply ...