Transferring databases w/o PHPMyAdmin

webdevRefinery Forum: Transferring databases w/o PHPMyAdmin - webdevRefinery Forum

Hide message

Show message

Welcome!

Mean coders suck. Learn from nice ones.

Join up (it's free!) whether you're just starting out or you're crazy advanced. Get tips from people who know what they're talking about, without being treated like the playground smelly kid. Because seriously, your school classes didn't teach you anything you wanted to know.

Hide message

View New Content
Pick a background

Cartoon Clouds Mountains Sunrise Clouds Green Clouds None

Page 1 of 1

You cannot start a new topic
You cannot reply to this topic

Marked

Group: Members
Posts: 117
Joined: 21-May 10
LocationChch, NZ
Expertise:HTML,CSS,PHP,SQL

Posted 01 January 2012 - 09:45 PM (#1)

Transferring databases w/o PHPMyAdmin

Hey guys,

I'm looking for software to transfer a MySQL database. I don't have access to PHPMyAdmin because my website is hosted for free by a member of the site, so I do not have access to the host. Instead I'm looking for software to install on the server so I can upload this database, which is around 600mb. I believe PHPMyAdmin can be installed this way but I have been told not to use this software.

Does anyone know of any other decent MySQL software that I could use? I need something reliable and that won't crash on me because the database is rather large.

Thanks in advance,
Mark.

NeilHanlon

Group: Members
Posts: 889
Joined: 08-July 10
LocationRowley, Massachusetts
Expertise:HTML,CSS,PHP,Java,Graphics

Posted 01 January 2012 - 10:03 PM (#2)

Do you have access to SSH? You can run the query from there...

Other than that, there aren't too many options, short of writing a PHP script to do it for you.

Lemon

I have a dream...

Group: Members
Posts: 697
Joined: 24-February 11
Expertise:HTML,CSS,PHP,Javascript,Node.js,SQL

Posted 01 January 2012 - 10:09 PM (#3)

For a database of that size and if you don't have SSH, you may want to look at BigDump. It'll import in small segments, meaning you protect yourself from running into issues with timeouts. However, it needs an export that hasn't used extended inserts, as it can't split the queries down to break up the task.

$|catrangle = frac{1}{sqrt{2}} |aliverangle + frac{1}{sqrt{2}} |deadrangle$
About

Daniel15

dan.cx

Group: Moderators
Posts: 3435
Joined: 17-April 10
LocationMelbourne, Australia
Expertise:HTML,CSS,PHP,Java,Javascript,Node.js,SQL

Posted 01 January 2012 - 10:59 PM (#4)

Ask nicely for SSH access (even jailed access should be fine) and use the

mysqldump

and

mysql

commands. Otherwise, upload a shell script or PHP script that uses mysqldump and run it.

I found a nice forum post on it (on another forum), and then realised that I was one of the contributors in the thread :lol:

http://forums.whirlp...archive/1340738

Daniel15! :D

Repeat after me: jQuery is not JavaScript. It is not the answer to every JavaScript-related question. When you have to write some JavaScript, do not instantly react with "Oh, I'll do that with jQuery!"

Spoiler

javascript:alert((''+[][[]])[!+[]+!+[]]+(![]+[])[+!+[]]+(''+!+[]/[])[+!+[]]+([![]]+[][[]])[+!+[]+[+[]]]+(''+!![])[+!+[]+!![]+!![]]+(![]+[])[!+[]+!+[]]+(+!+[])+(!+[]+!+[]+!+[]+!+[]+!+[]))

Kyek, on 16 November 2011 - 11:14 AM, said: