Page 1 of 1

what language to select for new database?

PostPosted: 01. August 2011 11:07
by garfy
I remember somebody told me to select latin bin, is that correct

Also where are my old databases? From my previous installed sites i copied all the files in htdocs folder but the databases are not copied

thank you

Re: what language to select for new database?

PostPosted: 01. August 2011 16:00
by JonB
well garfy - they are back in the old MySQL database.

The right thing to do is to backup the old MySQL databases, and then import the ones you need on your new installation.

I'd say the right thing to do would be to spend some time trying to get your head around how Drupal actually works. Books still work, you know...

8)

PS - you 'might' be able to copy the \xampp\mysql\data folder to its new location, but that is a very unsure thing.



yssf

Re: what language to select for new database?

PostPosted: 01. August 2011 16:02
by Altrea
garfy wrote:I remember somebody told me to select latin bin, is that correct

That really depends on the characters you want to save in the database. Which languages do you want to use?
If you have parts with userinteractions, which languages do you want to support for them?

utf8_general_ci is in many cases a good choice, because that supports all common languages plus many of the uncommon.

garfy wrote:Also where are my old databases? From my previous installed sites i copied all the files in htdocs folder but the databases are not copied


Databases are normally not stored in htdocs. MySQL for example saves it's databases normaly in it's folder named data.

P.S.: Damnit. JonB is the fastest man on earth 8)

Re: what language to select for new database?

PostPosted: 03. August 2011 23:06
by usefkl05
The files in your htdocs directory only contain the files you use for your websites, things that you can access directly with a web browser.

The data that was stored in your old MySQL installation was saved under the directory C:\xampp\mysql\data. If you get lucky, you might get away with just copying the old data directory into your newer XAMPP data directory, but the correct way to do this is to export it and then import it.

Andy