Moving site

NoFeaR / NFSMW · March 25, 2007, 11:09:12 PM

SMF Version: SMF 1.1.2
Hi guys. I'm movig my site from phonesector.com to symbiansector.com
Now i'm facing problems. My SQL upload limit is 2.048kb and my total SQL file is 6.2meg. I tried splittiong them up in sections. But it doesnt work.. i tried zipping it and gzip but still doesnt work. Getting this error. How can i inport my SQL database?

Enigma · March 25, 2007, 11:46:39 PM

Do you have shell access to your site?

If not you can always populate the tables manually. It takes a while, but you can open your .sql file in a text editor, then paste the sql queries into phpmyadmin for your forum's database.

NoFeaR / NFSMW · March 25, 2007, 11:51:53 PM

My smf_messages is 2.7meg. I cant load it alone and seems i cant zip or gzip it either. Also. How wil i know if a have shell access?

Enigma · March 25, 2007, 11:58:19 PM

shell access is a command promt that allows your to manage your account. When you say you can't zip the sql file, do you mean that the file can't be compressed or that phpmyadmin won't accept it?

NoFeaR / NFSMW · March 26, 2007, 12:06:12 AM

I really know absolutely nothing about this shell thing man. And also the phpmyadmin wont accept the zip and gzip stuff.

Enigma · March 26, 2007, 12:14:22 AM

What error does phpmyadmin give you?

When you backed up your database, did you do a comple backup with the database structure?

NoFeaR / NFSMW · March 26, 2007, 12:22:45 AM

Some thing about not gonfigured. And also i chose the one with the inpostant stuff

Enigma · March 26, 2007, 12:30:38 AM

Quote from: NFSMW on March 26, 2007, 12:22:45 AM
Some thing about not gonfigured. And also i chose the one with the inpostant stuff

ok. Can you go back and also check the box that says table structure too? I made the mistake of not checking it before and I would get errors when I imported the database. The problem was the data was good, but phpmyadmin couldn't find where to put it (the structure). That might be your problem.

NoFeaR / NFSMW · March 26, 2007, 12:35:18 AM

I did check the box

NoFeaR / NFSMW · March 28, 2007, 01:32:25 PM

How can i inport the mysql database please help me.

BBC · March 28, 2007, 01:36:42 PM

Quote from: NFSMW on March 28, 2007, 01:32:25 PM
How can i inport the mysql database please help me.

Don´t use phpmyadmin. I think it´s stupid with that limit.

Use myqsl administrator, it´s free, it has secure SSH remote login.

http://dev.mysql.com/downloads/gui-tools/5.0.html

NoFeaR / NFSMW · March 28, 2007, 01:51:28 PM

will it work with my host?

BBC · March 28, 2007, 01:58:27 PM

Quote from: NFSMW on March 28, 2007, 01:51:28 PM
will it work with my host?

Is it shared hosting?

Ask your host, call them, mail.

NoFeaR / NFSMW · March 28, 2007, 02:10:56 PM

its Godaddy hosting

BBC · March 28, 2007, 02:17:14 PM

I´ve got this answer with Google.

I got an official answer from the godaddy support:

Unfortunately we do not allow remote MySQL access with our hosting accounts.

This includes external connections to our MySQL databases.

This also includes outgoing connections to another database.

BBC · March 28, 2007, 02:29:32 PM

I would not stay with that host but it´s your decision.

Install Wamp server, import your database/s and then export them by tables.

It takes some time, not much, but that configuration would be usefull to you in future too.

Maybe someone has more simple solution, my brain is not working well right now.

NoFeaR / NFSMW · March 28, 2007, 02:44:18 PM

In inported by tables. And the messages one is 2.7meg and max aql file size is 2meg. Also i pain host and domain name from them. Pain 2years in advance. How can i move to another host? Will i lose my money?

NoFeaR / NFSMW · March 28, 2007, 03:15:47 PM

I need a good reliable host. With top featues.

metallica48423 · March 28, 2007, 04:39:05 PM

try googling a program called bigdump... it allows you to import databases larger than the single-file upload size.

as far as hosts go... Hosts and Hosting

emgage · April 11, 2007, 04:03:31 AM

your site? please dont help this dude. hes a dirty ripper who was admin on MY site hxxp:phonesector.com [nonactive] and ripped the database to create his own new site using ocntent from my site.
eNOUGH SAID NOFEAR

News:

Moving site