what language to select for new database?

Problems with the Windows version of XAMPP, questions, comments, and anything related.

what language to select for new database?

Postby garfy » 01. August 2011 11:07

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
garfy
 
Posts: 36
Joined: 14. January 2011 08:32

Re: what language to select for new database?

Postby JonB » 01. August 2011 16:00

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
User avatar
JonB
AF Moderator
 
Posts: 3210
Joined: 12. April 2010 16:41
Location: Land of the Blazing Sun
Operating System: Windows XP/7 - Fedora 15 1.7.7

Re: what language to select for new database?

Postby Altrea » 01. August 2011 16:02

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)
We don't provide any support via personal channels like PM, email, Skype, TeamViewer!

It's like porn for programmers 8)
User avatar
Altrea
AF Moderator
 
Posts: 11926
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 11 Pro x64

Re: what language to select for new database?

Postby usefkl05 » 03. August 2011 23:06

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
usefkl05
 
Posts: 3
Joined: 03. August 2011 22:36


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 131 guests