Saturday, 3 December 2011

Uploaded a database! 

I used "import" from a phpadmin screen on my server.
Initially I couldn't tell what sort of thing to import; the database on my hard disc had a load of files, but "export" with an option of .sql or .csv was a clue. I exported to the desktop.

My server already has an installation of drupal so the files were already on the server.

Several tweaks to get the server database to accept the one on the hard disc.
  • I had to give the one on the hard disc the same file name as the one already allocated. My host only allows one database per user which might be a reason for this.
  • I had to look at a screenload of database files on the server's phpmyadmin screen, scroll down past the bottom of the screen to find a way of selecting all the tickboxes, then choose delete from a dropdown menu. Textbook writers would probably found some way of saving the old work first.
  • The new data works with complaints and error messages about every third click about this thing changing or that thing not available. phpmyadmin also has a "repair" option for all ticked boxes, which I tried using, possibly in a way that helped.
  • I don't know what all these errors and grumbles mean. One is about keeping temp files in a place called C:/windows/temp which doesn't exist on my server. So the next job is to work out what it should be.
    Meanwhile I see that the repaired database is presented with a single error message next to about a quarter of the lines: " The storage engine for the table doesn't support r... " .
  • Somewhere on one of the Drupal report screens I got a change to change the place it puts temp files. I chose temp and have a way of making that folder not readable by strangers. So all should be well? No. I try the same "repair" command again and still have about a quarter of the database lines reporting error messages.
Discovered a video on this which is free at the moment Installing Drupal on a Server.
Discovered from that you have to turn-on the local install from Windows>Start>Acquia Dev Desktop>Control Panel . Turn it on and it goes. Don't turn it on and there's nothing to find in your browser.

for anyone interested in Ubercart video tutorials that are meant to make Drupal ecommerce relatively quick or possible compared to Magento or whatever a paid-for developer suggests, here are some links.

Transcribed videos: -
[Drupal 7 / Ubercart video tutorial 7 of 10 showed how to use the default catalog module]
[Drupal 7 / Ubercart video tutorial 8 of 10 showed an alternative flexible method of showing a catalog]
[Drupal 7 / Ubercart video tutorial 9 of 10 shows how to use product kits, stock, and order states]
[Drupal 7 / Ubercart video tutorial 10 of 10 shows a simple checkout, reports, and suggests a theme]

Getting gradually closer to installing...

After watching smooth, well contstructed videos on I'll miss them when it comes to time to subscribe. One or two are free but not many. I've just discovered another one or two on . The one on installing Drupal 7 begins by stating assumptions: you have done XYZ, then shows the "install" button being pressed and comments on the things that are a bit changed on the admin layout of Drupal 7 compared to Drupal 6. Now if I was making a video about how to go to the moon I could cut to the person at NASA pressing the "launch" button but it would not help those thousands of DIY-ers with bits of old rocket in their back yards trying to get started. I think my French teacher at school was like that in his lesson plans, but he did amuse us by being called Mr Willey so in a rambling way there was a positive side.

If Aquia are slick and wrote this installer, I guess they have pages and forums about installing it - maybe now that I am closer the 44 unanswered posts about things that go wrong will not be so daunting. Maybe the next stage is more like NASA and the rocket.