In a message dated 10/20/2006 5:00:46 P.M. Pacific Standard Time, mauro@carmo.info writes:
Thanks Kasimir Gabert,
Anyone could assure me that this would work? Or perhaps, there is another way I could set my phpMyAdmin to generate a db_domain with another name when I dump it.
Thanks mauro. You can never be sure until you try. It sounds right to me. The dump likely includes database names from the database being dumped. Even if you change a name readily visible at the top of the dump, their could be other instances further down. "Find and replace" (ctrl + H in Windows) can be used to replace every instance of the original database name in only one operation.
Ok... I get it!!! I get it!
I have a perfect copy of my site running perfectly... thank to you guys... ---
However, there was something that really troubles me:
Those configurations about Collation utf8, or utf8 bin, or latin, etc. are really problematic... and I am afraid of not being doing the right kind of dumping for backup.
I was dumping my Database, and after importing it to a different DB_. After that, I was getting problems with my collation... my accentuations was completely odd what caused several broken links.
Any one could give some insite here?
Thanks, mauro.
|-----Original Message----- |From: mediawiki-l-bounces@Wikimedia.org [mailto:mediawiki-l-bounces@Wikimedia.org] On Behalf Of | |In a message dated 10/20/2006 5:00:46 P.M. Pacific Standard Time, |mauro@carmo.info writes: | |Thanks Kasimir Gabert, | |Anyone could assure me that this would work? Or perhaps, there is another |way I could set my phpMyAdmin to generate a db_domain with |another name when I dump it. | |Thanks mauro. |You can never be sure until you try. It sounds right to me. The dump likely |includes database names from the database being dumped. Even if you change a |name readily visible at the top of the dump, their could be other instances |further down. "Find and replace" (ctrl + H in Windows) can be used to replace |every instance of the original database name in only one operation. |_______________________________________________ |MediaWiki-l mailing list |MediaWiki-l@Wikimedia.org |http://mail.wikipedia.org/mailman/listinfo/mediawiki-l | |-- |No virus found in this incoming message. |Checked by AVG Free Edition. |Version: 7.1.408 / Virus Database: 268.13.9/490 - Release Date: 10/20/2006 |
Mauro do Carmo wrote:
Those configurations about Collation utf8, or utf8 bin, or latin, etc. are really problematic... and I am afraid of not being doing the right kind of dumping for backup.
I was dumping my Database, and after importing it to a different DB_. After that, I was getting problems with my collation... my accentuations was completely odd what caused several broken links.
For a dedicated MediaWiki system I would recommend using MySQL 4.0, as we do, which doesn't have this problem. :)
If for some reason that's not an option, just be very careful with your mysqldump options. By default in 4.1 and higher, mysqldump performs LOSSY CONVERSION WHICH CAN CORRUPT YOUR DATA.
Set it specifically to output in the same charset as your database is set to to avoid this. I believe the option is called --charset or --default-charset; pass the appropriate value to match.
-- brion vibber (brion @ pobox.com)
Hi all,
Some one could tell me if my database has its coallation set right? It seems like it is set up in latin_bin, I don't remember to have done that. The link is http://pastey.net/3611-1gy3 . Thanks a lot. []'s mauro.
_________________________________________________ Server: MediaWiki: 1.6.8 PHP: 4.3.11 (apache) MySQL: 4.1.20-max-log phpMyAdmin - 2.8.0.1 * no access to shell command
Client: Win XP Home Edition SP2 Browser Mozila FireFox ____________________________________
|-----Original Message----- |From: mediawiki-l-bounces@Wikimedia.org [mailto:mediawiki-l-bounces@Wikimedia.org] On Behalf Of Mauro |do Carmo |Sent: Sunday, October 22, 2006 10:51 PM |To: 'MediaWiki announcements and site admin list' |Subject: Re: [Mediawiki-l] Site mirror or copy | |Ok... I get it!!! I get it! | |I have a perfect copy of my site running perfectly... thank to you guys... |--- | |However, there was something that really troubles me: | |Those configurations about Collation utf8, or utf8 bin, or latin, etc. are really problematic... and |I am afraid of not being doing |the right kind of dumping for backup. | |I was dumping my Database, and after importing it to a different DB_. After that, I was getting |problems with my collation... my |accentuations was completely odd what caused several broken links. | |Any one could give some insite here? | |Thanks, mauro. | | | ||-----Original Message----- ||From: mediawiki-l-bounces@Wikimedia.org [mailto:mediawiki-l-bounces@Wikimedia.org] On Behalf Of || ||In a message dated 10/20/2006 5:00:46 P.M. Pacific Standard Time, ||mauro@carmo.info writes: || ||Thanks Kasimir Gabert, || ||Anyone could assure me that this would work? Or perhaps, there is another ||way I could set my phpMyAdmin to generate a db_domain with ||another name when I dump it. || ||Thanks mauro. ||You can never be sure until you try. It sounds right to me. The dump likely ||includes database names from the database being dumped. Even if you change a ||name readily visible at the top of the dump, their could be other instances ||further down. "Find and replace" (ctrl + H in Windows) can be used to replace ||every instance of the original database name in only one operation. ||_______________________________________________ ||MediaWiki-l mailing list ||MediaWiki-l@Wikimedia.org ||http://mail.wikipedia.org/mailman/listinfo/mediawiki-l || ||-- ||No virus found in this incoming message. ||Checked by AVG Free Edition. ||Version: 7.1.408 / Virus Database: 268.13.9/490 - Release Date: 10/20/2006 || | |-- |No virus found in this outgoing message. |Checked by AVG Free Edition. |Version: 7.1.408 / Virus Database: 268.13.9/490 - Release Date: 10/20/2006 | |_______________________________________________ |MediaWiki-l mailing list |MediaWiki-l@Wikimedia.org |http://mail.wikipedia.org/mailman/listinfo/mediawiki-l | |-- |No virus found in this incoming message. |Checked by AVG Free Edition. |Version: 7.1.408 / Virus Database: 268.13.9/490 - Release Date: 10/20/2006 |
mediawiki-l@lists.wikimedia.org