Zen Cart Logo
Forums / Upgrading from 1.3.x to 1.3.9 / anybody know how to use phpmyadmin?

anybody know how to use phpmyadmin?

Locked

Views: 8,423

Results 1 to 14 of 14
This thread is locked. New replies are disabled.
29 Sep 2006, 9:37 PM
#1
Join Date:
Apr 2006
Posts:
41
Plugin Contributions:
0

anybody know how to use phpmyadmin?

OK,
just wanted to upgrade from Zen 1.3.1 to 1.3.5 but now I have to download/install special phpmyadmin software just to back up mySQL?
OK so I installed phpmyadmin, transferred all files to my parent dir and it tells me that it can't load or save configuration, please make writable folder bla bla bla.
I already have fixed file permissions to the config folder in the phpmyadmin folder on the main directory. ASPNET has read, write & execute permissions.
Everyone has read and execute permissions and I have all permissions. So what gives.
There's got to be a simple way to back up MySQL without all this work. And please don't tell me there's a back up button in my Cpanel on the server, because I've looked everywhere and there's none. Anyone else using Crystaltech hosting that can do this??

29 Sep 2006, 9:50 PM
#2
merlinpa1969 avatar

merlinpa1969

Totally Zenned

Join Date:
Mar 2004
Posts:
13,031
Plugin Contributions:
4

Re: anybody know how to use phpmyadmin?

first of all you didnt need to download any php my admin

your host should have that installed all it is is a gui interface with mysql.

you need to look through crystaltechs manuals and forums, they will be the best place to have these answers,

if you are using cpanel there is a link in there called mysql
at the bottom of that page is a link into phpmyadmin

29 Sep 2006, 11:08 PM
#3
Join Date:
Apr 2006
Posts:
41
Plugin Contributions:
0

Re: anybody know how to use phpmyadmin?

  1. I was told here to download myphpAdmin to do this

  2. You keep saying there's a backup button in CPanel. Where? On my servers control panel I have a button Database with the following subcatagories

MySQL
MySQL Admin
MySQL Database Info
MySQL Connections
MySQL Query Test
Database Restore
Datasource Admin

Absolutely NONE of these mention ANYWHERE that there is a backup button.

Are you thinking of some application I'm not aware of?

  1. My host Crystaltech has no GUI that will let me backup my SQL database.

  2. If this is such a lengthy issue just to back up my rinky dink database (40 products) should I just start over?

  3. Lastly, what are the drawbacks to just staying with Zen 1.3.1? I haven't even started the upgrade to 1.3.5 and I'm already frustrated.

29 Sep 2006, 11:56 PM
#4
barco57 avatar

barco57

Totally Zenned

Join Date:
Apr 2006
Location:
West Salem, IL
Posts:
2,845
Plugin Contributions:
0

Re: anybody know how to use phpmyadmin?

Looking at crystaltechs' site you use a different layout to the control panel. You need to use the MySql admin as far as I can tell. Grab a screen shot of that page and can help you futher

30 Sep 2006, 12:22 AM
#5
barco57 avatar

barco57

Totally Zenned

Join Date:
Apr 2006
Location:
West Salem, IL
Posts:
2,845
Plugin Contributions:
0

Re: anybody know how to use phpmyadmin?

According to crystaltech knowledge base it looks like you can load phpmyadmin into your root folder of your site and after seting up the config file you would call it with http:https://www.yoursite.com/phpmyadmin/index.php On phpMyAdmin it is not a backup it is called an export.

It also looks like you can download mySQL administrator from the mySQL site and run it on your local machine to manage the DB.

30 Sep 2006, 2:24 AM
#6
Join Date:
Apr 2006
Posts:
41
Plugin Contributions:
0

Re: anybody know how to use phpmyadmin?

After loading everything in I have tried http:https://www.yoursite.com/phpmyadmin/index.php but I just get an Erroe #2003 - Server is not responding. It goes on to say that I probably did not create the configuration file, BUT I DID! I also configured the file permission settings for this folder as requested in the documentation. I've already tried deleting everything and starting over as well.

I'm downloading MySQL 5.0 right now and will install this weekend. So should I delete all this phpmyadmin stuff from my parent directory?

Thanks for the help

30 Sep 2006, 2:33 AM
#7
merlinpa1969 avatar

merlinpa1969

Totally Zenned

Join Date:
Mar 2004
Posts:
13,031
Plugin Contributions:
4

Re: anybody know how to use phpmyadmin?

rather than messing with all this other stuff
try going to the
MySQL Admin link that you spoke about earlier

no sense in going to mysql 5

30 Sep 2006, 2:41 AM
#8
Join Date:
Apr 2006
Posts:
41
Plugin Contributions:
0

Re: anybody know how to use phpmyadmin?

Thanks Merlinpa1969, I confused MySQL 5.0 for MySQL Admin. I just downloaded MySQL Admin and will try.

Should I get rid of the phpMyAdmin stuff from my parent dir first?

30 Sep 2006, 2:45 AM
#9
merlinpa1969 avatar

merlinpa1969

Totally Zenned

Join Date:
Mar 2004
Posts:
13,031
Plugin Contributions:
4

Re: anybody know how to use phpmyadmin?

Honestly,
I can say that if you have to jump this many hurdles just to get a back up of your DB,
you need to find new service..
LOL

there should be a link that you can hit that will take you INTO your databasae without downloading anything,

or having to add anything

30 Sep 2006, 2:47 AM
#10
Join Date:
Apr 2006
Posts:
41
Plugin Contributions:
0

Re: anybody know how to use phpmyadmin?

I agree. I'm not the only one. I found quite a bit of the same issues on Crystaltechs forums with the same exact problem "where's the freakin' back up button?"

So back to my question, should a delete the phpmyadmin stuff from my parent directory?

30 Sep 2006, 3:02 AM
#11
merlinpa1969 avatar

merlinpa1969

Totally Zenned

Join Date:
Mar 2004
Posts:
13,031
Plugin Contributions:
4

Re: anybody know how to use phpmyadmin?

I have no idea what to tell you

Our customers can hit a simple link to go to phpmyadmin

3 Oct 2006, 3:29 PM
#12
Join Date:
Apr 2006
Posts:
41
Plugin Contributions:
0

Re: anybody know how to use phpmyadmin?

Just wanted to let everyone know that everything worked fine after loosing phpmyadmin-2.9.0 and installing phpmyadmin-2.5.5. Must have been an issue with the server.

Thanks everyone for the help.

17 Sep 2008, 3:44 AM
#13
renee avatar

renee

New Zenner

Join Date:
Jan 2008
Posts:
9
Plugin Contributions:
0

Re: anybody know how to use phpmyadmin?

Old thread but perhaps someone can help. New to ZenCart, helping out a friend. The store is using BlueHost for their site.

I'm trying (unsucessfully) to get MyPHPAdmin working. I've downloaded and extracted to my local machine as instructed. I'm stuck on the very simple step of needing to upload the files to the ftp box. What isn't clear by the readme is what folder exactly I should upload the files to. It states "..extract/upload all the files to your webserver's document root..".

What folder should this be for ZenCart?

More dumb questions to follow once I get this part figured out. :P

Email me directly at ehstetson @ hotmail . com

Thanks! -E

17 Sep 2008, 5:31 AM
#14
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: anybody know how to use phpmyadmin?

You might want to check with your hosting site ... if I am not mistaken they provide you with phpMyAdmin in your Control Panel ... :unsure: