Zymic Forums

Webmaster resources

Zymic IRC Server

Chat in real time at irc.zymic.com - Learn More

Welcome

Welcome to the Zymic webmaster forums. Our forums are here to provide people the free ability to discuss a range of websites related topics such as design, development coding and marketing.

In order to post you will need to register for a zymic account or if you already have one simply login by using the form on the left.

left Zymic Webmaster ForumsZymic Free Web HostingDatabases & MySQL right
  Reply to this topic Start new topic
left right
Cheops
post May 30 2009, 08:17 PM
Post #1


Newbie
*

Group: Members
Posts: 4
Joined: 28-May 09
Member No.: 97,060



My task is to transfer MediaWiki onto the hosting. Wiki is not latin. So the task is connected with well known encoding problems.

1) Approved way of error-free transferring is via custom dumper. Custom dumper accepts gzipped and bzipped2 dumps, but there's no coressponding php extensions here.

2) Dumper accepts unpacked dumps too. But 7Mb dump when unpacked becomes 40Mb. Too large to upload via ftp.

3) No way found to upload archive and unpack in on the server.

4) Let's see what we have with standard, error prone way. Some phpMyAdmin v2.11.4 found at http://www.uuuq.com/phpmyadmin/. To say it's extremely slow will be wrong. It's inoperable. Couldn't feast eyes with a page.

5) Found another phpMyAdmin v3.1.3.1 at http://www.uuuq.com/phpmyadmin-new/. It works, but extremely slow. After lotsa tries import started, but failed with "#1153 - Got a packet bigger than 'max_allowed_packet' bytes"

6) Dunno what database tool is at http://www.uuuq.com/phpminiadmin.php. It doesn't accept correct login (cheops_root - 11 characters) and correct password.

So, six alternatives were tested failed.
Is there seventh way which will work? smile.gif
Go to the top of the page 
 
  + Quote Post
Ed
post May 30 2009, 08:56 PM
Post #2


Outrageously Uber Ninja
*******

Group: Administrators
Posts: 2,529
Joined: 11-March 07
From: UK
Member No.: 9



Drop by IRC and I'll import it for you. smile.gif

phpmyadmin-new usually works for most imports, could just be because it's a large database. Have you tried using the staggered option in phpmyadmin-new, so it picks up from where it left off.
Go to the top of the page 
 
  + Quote Post
Cheops
post May 30 2009, 11:17 PM
Post #3


Newbie
*

Group: Members
Posts: 4
Joined: 28-May 09
Member No.: 97,060



QUOTE(Bread @ May 30 2009, 08:56 PM) *
Drop by IRC and I'll import it for you. smile.gif

I'm sorry, but my English is very poor. In chat I'm afraid you will not understand me at all unsure.gif Would you please converse with me in forum? unsure.gif

QUOTE(Bread @ May 30 2009, 08:56 PM) *
phpmyadmin-new usually works for most imports, could just be because it's a large database.

It succeeded at last. But above mentioned encoding trouble happened mellow.gif It's a problem of MediaWiki, not MySQL. Maybe it could be solved, but many experiments will be necessary. How long it takes if successful import is so rare? unsure.gif

QUOTE(Bread @ May 30 2009, 08:56 PM) *
Have you tried using the staggered option in phpmyadmin-new, so it picks up from where it left off.

Of course, I wouldn't venture at non-staggered import.

Is there any way to utilize custom dumper script? It's proven to work correctly.
Dumper only needs either unpacked dump or PHP extension (bz2, bzip2 or zlib). I understand that nobody will set up the extension, but could you unpack uploaded dump for me?

Thanks in advance,
Cheops
Go to the top of the page 
 
  + Quote Post
 Reply to this topic Start new topic
left right
0 Members:
left right
 


Lo-Fi Version Time is now: 22nd November 2009 - 01:02 AM