User Name
Password

Go Back   Planetarion Forums > Non Planetarion Discussions > Programming and Discussion

Reply
Thread Tools Display Modes
Unread 11 Mar 2004, 16:46   #1
Mong
Forever Delayed
 
Join Date: Sep 2000
Location: www.netgamers.org
Posts: 1,475
Mong is on a distinguished road
PHPMyAdmin Question

Hi,

The only MySQL access I have on the remote server is via PHPMyAdmin.

The export feature is nice... creates the SQL script with the DROP/CREATE and INSERT statements.

Problem is, this can be a BIG file. So PHPMyAdmin on my local machine borks when I try and import it. Same with EMS MySQL Manager (the GUI I use).

So how do YOU PERSONALLY copy large MySQL databases, if you have the same access to the live server?

Ta,

M.
__________________
Firefly Oper and General l4m3r - "I Do Stuff"

O2 Rip-off campaign

<vampy> plus i hate people ... i despise humanity as a whole

pablissimo "I'm still geting over the fact you just posted a pic of your own vomit"
Mong is offline   Reply With Quote
Unread 11 Mar 2004, 19:13   #2
Supernova9
m u p p e t
 
Join Date: May 2001
Location: Whenever Wherever
Posts: 477
Supernova9 is infamous around these parts
Re: PHPMyAdmin Question

Chunk the script, i.e. separate down, maybe tables at a time.
__________________
Supernova9 is offline   Reply With Quote
Unread 13 Mar 2004, 15:46   #3
Freedom
Howling Rain
 
Join Date: Jul 2003
Location: England
Posts: 32
Freedom will become famous soon enoughFreedom will become famous soon enough
Re: PHPMyAdmin Question

I'd use the shell access, but with only havign phpmyadmin to use I'd follow Supernova9 example of breaking it down into tables at a time. Also, you could ask to have your script execution time increased =)
__________________
To live in Freedom we must dwell in War.
Freedom is offline   Reply With Quote
Unread 13 Mar 2004, 22:34   #4
Karmulian
Get Stuffed
 
Karmulian's Avatar
 
Join Date: Jun 2000
Location: Cheltenham, England
Posts: 647
Karmulian is on a distinguished road
Re: PHPMyAdmin Question

how are you importing it on your machine?
__________________
___________________________________
I used to work for PA.. and all i got was this shit avatar
___________________________________
Karmulian is offline   Reply With Quote
Unread 13 Mar 2004, 23:27   #5
Mit
Let battle commence
 
Mit's Avatar
 
Join Date: Feb 2002
Location: England
Posts: 732
Mit is a jewel in the roughMit is a jewel in the roughMit is a jewel in the rough
Re: PHPMyAdmin Question

use the 'mysql' client and then the source command

Quote:
source (\.) Execute a SQL script file. Takes a file name as an argument.
__________________
Mit
http://tim.igoe.me.uk - Development Blog
Whats on TV now - UK TV Guide

<Mendosa> mit is a cute cudlly toy that will be in the shops by christmas
<mig-work> ur now my eternal fav pa god
<Squiz> i name thee, Sir Mit
<Zeus> u my friend are a true gamer I knew u were
Mit is offline   Reply With Quote
Unread 17 Mar 2004, 16:53   #6
Mong
Forever Delayed
 
Join Date: Sep 2000
Location: www.netgamers.org
Posts: 1,475
Mong is on a distinguished road
Re: PHPMyAdmin Question

Mit, I can't do that. For the reason (clearly) explained above, thanks anyway
__________________
Firefly Oper and General l4m3r - "I Do Stuff"

O2 Rip-off campaign

<vampy> plus i hate people ... i despise humanity as a whole

pablissimo "I'm still geting over the fact you just posted a pic of your own vomit"
Mong is offline   Reply With Quote
Unread 17 Mar 2004, 17:06   #7
Mit
Let battle commence
 
Mit's Avatar
 
Join Date: Feb 2002
Location: England
Posts: 732
Mit is a jewel in the roughMit is a jewel in the roughMit is a jewel in the rough
Re: PHPMyAdmin Question

u only stated that u didn't have shell acc to the REMOTE machine, so i assumed u had it on local and could do that :P
__________________
Mit
http://tim.igoe.me.uk - Development Blog
Whats on TV now - UK TV Guide

<Mendosa> mit is a cute cudlly toy that will be in the shops by christmas
<mig-work> ur now my eternal fav pa god
<Squiz> i name thee, Sir Mit
<Zeus> u my friend are a true gamer I knew u were
Mit is offline   Reply With Quote
Unread 21 Mar 2004, 05:01   #8
Gayle29uk
Bitch
 
Join Date: Jun 2002
Location: North Yorkshire
Posts: 3,848
Gayle29uk is just really niceGayle29uk is just really niceGayle29uk is just really niceGayle29uk is just really nice
Re: PHPMyAdmin Question

CSV and LOAD DATA INFILE.
__________________
ACHTUNG!!!
Das machine is nicht fur gefingerpoken und mittengrabben. Ist easy
schnappen der springenwerk, blowenfusen und corkenpoppen mit
spitzensparken. Ist nicht fur gewerken by das dummkopfen. Das
rubbernecken sightseeren keepen hands in das pockets. Relaxen und vatch
das blinkenlights!!!
Gayle29uk is offline   Reply With Quote
Unread 23 Mar 2004, 22:05   #9
Intrepid00
Registered User
 
Join Date: Aug 2000
Posts: 1,967
Intrepid00 is an unknown quantity at this point
Re: PHPMyAdmin Question

Ask the admin to do it. Espically if your paying.
Intrepid00 is offline   Reply With Quote
Unread 25 Mar 2004, 16:49   #10
SirKillALot
The One And Only
 
Join Date: Mar 2004
Location: Oppegård, Norway
Posts: 7
SirKillALot is an unknown quantity at this point
Re: PHPMyAdmin Question

There is many Programmes made for MySQL controlling. MySQL-Boss for example.

An option there is to copy from DB to DB. Then you just insert all the access things like username, pass and location. And then it moves it by itself. No size problems. (I haven't had any.)
__________________
SirKillALot is offline   Reply With Quote
Unread 25 Mar 2004, 16:52   #11
pablissimo
Henry Kelly
 
pablissimo's Avatar
 
Join Date: Apr 2000
Posts: 7,374
pablissimo has ascended to a higher existance and no longer needs rep points to prove the size of his e-penis.pablissimo has ascended to a higher existance and no longer needs rep points to prove the size of his e-penis.pablissimo has ascended to a higher existance and no longer needs rep points to prove the size of his e-penis.pablissimo has ascended to a higher existance and no longer needs rep points to prove the size of his e-penis.pablissimo has ascended to a higher existance and no longer needs rep points to prove the size of his e-penis.pablissimo has ascended to a higher existance and no longer needs rep points to prove the size of his e-penis.pablissimo has ascended to a higher existance and no longer needs rep points to prove the size of his e-penis.pablissimo has ascended to a higher existance and no longer needs rep points to prove the size of his e-penis.pablissimo has ascended to a higher existance and no longer needs rep points to prove the size of his e-penis.pablissimo has ascended to a higher existance and no longer needs rep points to prove the size of his e-penis.pablissimo has ascended to a higher existance and no longer needs rep points to prove the size of his e-penis.
Re: PHPMyAdmin Question

I had large dumps that I needed to recreate a DB with, so just split the file into chunks of a couple hundred k or so then executed them manually with the whole uploady-executey-statementy thing. Took a while but it was better than watching the script time out every time.
__________________
You're now playing ketchup
pablissimo is offline   Reply With Quote
Reply


Thread Tools
Display Modes

Forum Jump


All times are GMT +1. The time now is 14:07.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2002 - 2018