Jump to content

Quick Tutorial on how to back up and restore DB


Guest jmartinez

Recommended Posts

Guest dreamkingdom

I'm another Newbie here! :wacko: Where do I find this "PHPMyAdmin" area? Is it in my Cpanel? I guess y'all are used to these beginner's questions...

I need to have some mods installed and have been told to backup my cubecart files and database....I have read a little bit of the tutorial on the backup...Does it cover every single step for the novice to follow and get it right... if not, can someone give me the "baby step" instructions..LOL

Thanks so much for any help you can offer...

Look forward to hearing from you.

Peace,

Stephanie

Link to comment
Share on other sites

  • 3 weeks later...
  • 4 months later...
Guest Cellular Amps LLC

Just thought I would pipe up and say I had to use this today, switched hosting. after installing cubecart fresh again, then loading all my images, I then imported my database that I thankfully saved just days ago. I got one error during the install. Sorry I didn't copy the error down. But all appears well so far, no issues.. all cat, products and images populated where they were supposed to.

Again No issues noted as of yet.

Link to comment
Share on other sites

  • 4 weeks later...
  • 1 month later...

A lot of people .are. either changing webhosts, wanting to backup or restore their databases...

Did this and divined a major mess-up spot in the procedure. It involves backing up (moving/copying) from/to a *nix platform and IIS6 platform. On an IIS6 platform, the mySQL system variable "lower_case_table_names" probably should be set equal to 2 as this will preserve the case of table names during a CREATE statement.

I had requested a SQL script be created by phpMyAdmin of my (production) store running *nix, then executed that script on a localserver (development) store running IIS6. The table names all came out lower case as viewed in MySQL Query Browser (MySQL AB). Knowing that PHP is case-sensitive, I was concerned what problems this might cause.

Apparently none.

However, going the other way may be highly problematic - IMHO. If the MySQL administrator on the IIS6 system allows for the total disregard of lettercase, I see problems ahead when moving/copying a store to *nix. The MySQL system variable "lower_case_table_names" may be by default set to equal 1 during installation on IIS6 systems, which is to CREATE all table names in lowercase and to convert all queries to lowercase.

(Corrections to my conclusions are welcome.)

Link to comment
Share on other sites

  • 3 weeks later...
Guest realwebvalues

I plan to use your tutorial, however, I do not know how to access the starting point, myphpadmin. I am new to cubecart and need to backup my data. I installed CubeCart in the root and I need to reinstall it into a subdirectory then import the data in the new install then uninstall the cube cart that is in the root. Please advise?

Thanks

I completed the backup, how do I know it's good?

I need to install cube cart in a sub folder, the install first wants me to remove existing which is in my root.

Link to comment
Share on other sites

  • 1 month later...

THANK YOU jmartinez for these instructions - the screenshots are especially useful! :o

Since I've gone from 1) Not having a clue about backing up databases, or using phpMyAdmin, to 2) Successfully making my first database backup, can I add a few extra hints for beginners using 1 and 1 hosting, like me?

I don't have CPanel, or at least I don't think so. But phpMyAdmin is already on the 1 and 1 site.

So if you use them, go to:

1. Control Panel > Look for 'Websites and Applications' > Click on 'MySQL Administration' icon.

You should see a panel with your Cubecart database information there. That's the one you set up to install Cubecart. The 'phpMyAdmin' button is on the panel. Click that.

4. This brings up the phpMyAdmin screen. However, instead of a dropdown box in the top left, you may find a clickable link saying 'db89898989...'. Click that.

5. You should then have a screen which looks a lot like the one in the tutorial. Follow the instructions to the letter.

6. A problem: I couldn't rename the database on saving it. Doing so left me with a corrupted file. When I saved with the name 1 and 1 gave it, it worked. I was able to rename the file afterwards.

7. Check the downloaded file content: it should contain recognisable data, and not a corrupted jumble.

Hope this helps someone. Thanks for reading!

Link to comment
Share on other sites

  • 1 year later...
Guest thunder_esl

Hi,

I read the tutorial and i tried to back up my database but couldn't. I went into phpmyadmin and followed the instructions on how to back up the database but i get the following message.

export.php: Missing parameter: what (FAQ 2.8)

export.php: Missing parameter: export_type (FAQ 2.8)

I dont think it is anything to do with the cubecart database because i tried exporting other databases and i keep getting the same message i think the problem is with phpmyadmin.

I have looked at the FAQ 2.8 but i have no idea what that is talking about.

Can someone please explain simply how to fix phpmyadmin. If not could someone suggest another easy to use piece of software. Is there a way to find the mysql database file on my server and just transfer it by FTP?

Thanks.

Link to comment
Share on other sites

Guest thunder_esl

hey,

Thanks. I asked them but they didnt provide much help. I got it to work now i stopped using phpmyadmin, instead i just used the backup function in my cpanel it worked and i think its easier than using phpmyadmin.

Thanks.

Link to comment
Share on other sites

  • 6 months later...
Guest vitamin0s

Very Good and informative tutorial which will help the newbie who is a little nervous about restoring their database backup for their shopping cart

Link to comment
Share on other sites

  • 4 weeks later...
  • 4 months later...
  • 1 month later...
Guest speckled

I have a question regarding the skins, etc when restoring your back up. I did a back up and restor trial, but my images and changes to the skin, etc did not show up on my restore - how do I get those modifications into my restore after a back up?

Thanks in advance for the info.

Link to comment
Share on other sites

  • 1 year later...
Guest Woumomish
dapoxetina pareri ivn news dapoxetina comprare N3 priligy dapoxetina vendita UtHU acquisto priligy PkC comprare dapoxetina N3 priligy interazioni N3 priligy ultimi aggiornamenti PIH priligy senza prescrizione Au priligy dapoxetina effetti collaterali wAa priligy 30 mg laET priligy scheda tecnica IC priligy vendita Zuo dapoxetina priligy NTB dapoxetine in vendita laET comprare priligy news UW Dapoxetina farmacia u8 acquistare priligy italia UW priligy vendita dove PIH Dapoxetina quanto costa rBB priligy como tomar Bnw priligy viagra UW dapoxetina p00 acquistare priligy on line SaIl dapoxetina ricetta laET priligy euro YU7 priligy svizzera 4N priligy viagra generico DNh0 priligy dapoxetina farmacia Zuo dapoxetina in farmacia UW dapoxetina ricetta Zuo priligy dapoxetina online SaIl acquisto priligy online N3 priligy medico PkC dove comprare priligy NTB priligy e viagra insieme u8 priligy italia N3 priligy generico italia HJ dapoxetina generico SaIl comprare priligy generico p00 priligy in commercio p00 priligy paypal YU7 priligy medico 4N priligy assunzione rBB priligy dapoxetina costo UW dapoxetina generica ivn dapoxetina serve la ricetta DNh0 dapoxetina equivalente Dq priligy interazioni NTB priligy online zFigr acquistare priligy italia RZY comprare priligy news PkC priligy quanto dura l'effetto KH priligy 60 mg HJ dapoxetina ci vuole la ricetta UtHU acquisto priligy PIH priligy dapoxetina prezzo YU7 priligy su internet IC la dapoxetina UW priligy serve ricetta ivn priligy interazioni Sh8 dapoxetine online NTB priligy foglio illustrativo RZY dapoxetina funziona IC dapoxetina in natura u8 priligy compresse DNh0 dapoxetina ricetta N3 priligy generico hg priligy viagra generico Dq dapoxetina effetti collaterali UtHU priligy medico YU7 priligy 90mg zFigr priligy in svizzera 4N priligy online p00 priligy vendita IC dapoxetina in italia Au priligy compresse UW priligy online RZY priligy dapoxetina vendita SaIl priligy medico u8 priligy sito p00 priligy dapoxetina IC priligy sito rBB acquistare priligy UW priligy acquistare KH priligy offerta UtHU dapoxetina naturale N3 priligy in italia p00 priligy foglio illustrativo HJ dapoxetina in italia UW dapoxetina on line rBB priligy generico NTB priligy indicazioni terapeutiche gZ priligy foglio illustrativo Zuo priligy pillola Dq priligy interazioni rBB dapoxetina comprare p00 dapoxetina eiaculazione precoce rBB priligy medico KH priligy 60 mg Bnw priligy vendita dove Sh8 priligy in italia KH dapoxetina naturale hg priligy senza prescrizione YU7 dapoxetina priligy farmaco UtHU comprare priligy generico SaIl dapoxetine generico gZ priligy scheda tecnica IC priligy interazioni rBB priligy vendita dove Bnw priligy acquisto on line 4N priligy 90mg PkC priligy prescrizione hg priligy originale rBB priligy pastiglie NTB priligy compresse PIH priligy in italia KH priligy bugiardino UtHU priligy sito YU7 priligy 30 mg UW prezzo priligy in farmacia KH comprare priligy news PIH acquistare priligy on line gZ dapoxetina funziona UtHU vendita priligy online YU7 priligy 60 mg PkC dapoxetina eiaculazione precoce N3 priligy 30 compresse p00 dapoxetina 30 mg DNh0 dapoxetina in farmacia Bnw farmaco priligy RZY priligy dapoxetina prezzi Dq priligy prezzo NTB dapoxetina priligy farmaco RZY priligy medico Sh8 dapoxetina pareri YU7 dapoxetina in natura IC priligy medicinale KH priligy originale Au priligy azione 4N dapoxetina comprare PkC
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...