Scratch

RedRocker227 · 2012-11-04 10:45:54

i've been trying to use MySQL Dumper to import a database since it's too big to import in phpMyAdmin, when it asks for the database details, what do you enter? the details of the database you're transferring from or the one you're transferring to?

and if it's the former is there a different way of importing a database that's too big for phpMyAdmin, since 000webhost (and free hosts in general as far as i know) only lets you connect to databases associated with your account, so you can't connect to one of 1freehosting's databases which is what i'm trying to do

when i enter the details i just get "Cannot connect to database"

bobbybee · 2012-11-04 11:35:44

You dump the SQL file, then import it on the other machine (the former I guess)

stevetheipad · 2012-11-04 11:48:54

The Misc Forums = down.

RedRocker227 · 2012-11-04 15:26:52

stevetheipad wrote:
The Misc Forums = down.

thanks for actually answering the question and not stating the obvious

RedRocker227 · 2012-11-04 15:29:15

bobbybee wrote:
You dump the SQL file, then import it on the other machine (the former I guess)

i'm still not understanding fully

so if the database is currently on 1freehosting and you're transferring it to 000webhost, when it asks for the database details, you enter the details of the 1freehosting database?

bobbybee · 2012-11-04 15:38:56

No. Go to 1freehposting PMA, and go to export. Export as a sql file. Then in dumper, put in the the 000webhost details, using that sql.

DISCLAIMER: I've never used MySQL Dumper, nor know what I'm talking about (latter is a joke)

RedRocker227 · 2012-11-04 16:01:53

so i upload the .sql file to 000's FTP thingy?

thank you

RedRocker227 · 2012-11-06 10:38:59

RedRocker227 wrote:
so i upload the .sql file to 000's FTP thingy?

bobbybee · 2012-11-06 11:43:38

Yea

fg123 · 2012-11-06 15:32:32

RedRocker227 wrote:
so i upload the .sql file to 000's FTP thingy?

thank you

That works, but it's better to go into 000's PMA, and click import, then select the file. It will run the contents of the file into the DB.

RedRocker227 · 2012-11-07 12:37:10

thanks for your help

fg123 wrote:
RedRocker227 wrote:
so i upload the .sql file to 000's FTP thingy?

thank you
That works, but it's better to go into 000's PMA, and click import, then select the file. It will run the contents of the file into the DB.

the file size is like six times more than you're allowed, so i can't do that

Scratch

archived forums

#1 2012-11-04 10:45:54

MySQL Dumper

#2 2012-11-04 11:35:44

Re: MySQL Dumper

#3 2012-11-04 11:48:54

Re: MySQL Dumper

#4 2012-11-04 15:26:52

Re: MySQL Dumper

stevetheipad wrote:

#5 2012-11-04 15:29:15

Re: MySQL Dumper

bobbybee wrote:

#6 2012-11-04 15:38:56

Re: MySQL Dumper

#7 2012-11-04 16:01:53

Re: MySQL Dumper

#8 2012-11-06 10:38:59

Re: MySQL Dumper

RedRocker227 wrote:

#9 2012-11-06 11:43:38

Re: MySQL Dumper

#10 2012-11-06 15:32:32

Re: MySQL Dumper

RedRocker227 wrote:

#11 2012-11-07 12:37:10

Re: MySQL Dumper

fg123 wrote:

RedRocker227 wrote:

Board footer