469,927 Members | 1,857 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,927 developers. It's quick & easy.

export local DB to Server DB

Hi,
can anybody refer me to a tool so that i can upload data from my local
mysql DB to server DB without phpmyadmin. I have FTP and other access
to server. my DB is like 100 MB.
Regards
Jaunty
Jul 17 '05 #1
9 2192
On 14 Jul 2004 11:38:19 -0700, sm***********@hotpop.com (Jaunty Edward) wrote:
can anybody refer me to a tool so that i can upload data from my local
mysql DB to server DB without phpmyadmin. I have FTP and other access
to server. my DB is like 100 MB.


http://dev.mysql.com/doc/mysql/en/SELECT.html
See the OUTFILE clause.

http://dev.mysql.com/doc/mysql/en/LOAD_DATA.html

Doesn't involve PHP, so offtopic for these groups, try a MySQL group or
mailing list.

--
Andy Hassall <an**@andyh.co.uk> / Space: disk usage analysis tool
http://www.andyh.co.uk / http://www.andyhsoftware.co.uk/space
Jul 17 '05 #2
Jaunty Edward wrote:
can anybody refer me to a tool so that i can upload data from my local
mysql DB to server DB without phpmyadmin. I have FTP and other access
to server. my DB is like 100 MB.


Hi Jaunty,
Most servers will enforce a limit for PHP scripts way below 100Mb.
Perhaps the best way to import it it to use SSH if your host will allow it.

Export the file using mysqldump on your local server.

FTP the file to your server, log in through SSH and then use
mysql -u <username> -p < whatever.sql

Enter your mysql password at the prompt and the contents of the sql file
will be executed.

Regards,

Andy
Jul 17 '05 #3
Jaunty Edward wrote:
can anybody refer me to a tool so that i can upload data from my local
mysql DB to server DB without phpmyadmin. I have FTP and other access
to server. my DB is like 100 MB.

I use MySQLPHPbak to make backups files (sql files), thise you can then upload
to another server and import into mysql with the
"\. /path/to/mysql_data_file.sql".

It seems like version 0.2.2 was the last version released, but haven't found
any place where to download that one. Zend does have version 0.1.1 on their
homepage, I suggest you make a search for "MySQLPHPbak" at google.com.
//Aho
Jul 17 '05 #4
Andy Barfield wrote:
Export the file using mysqldump on your local server.

FTP the file to your server, log in through SSH and then use
mysql -u <username> -p < whatever.sql

....and I should have said that you need to check the manual pages for
mysql and mysqldump for a list of options...

http://dev.mysql.com/doc/mysql/en/mysql.html
http://dev.mysql.com/doc/mysql/en/mysqldump.html

regards, Andy
Jul 17 '05 #5
> Jaunty Edward wrote:
can anybody refer me to a tool so that i can upload data from my local mysql DB to server DB without phpmyadmin. I have FTP and other access to server. my DB is like 100 MB.

I use MySQLPHPbak to make backups files (sql files), thise you can

then upload to another server and import into mysql with the
"\. /path/to/mysql_data_file.sql".

It seems like version 0.2.2 was the last version released, but havenít found any place where to download that one. Zend does have version 0.1.1 on their homepage, I suggest you make a search for "MySQLPHPbak" at google.com.
//Aho

J.O.
I am interested in incremental backups of my mysql dbís, since they
are too large. Is this the right solution for that?

--
http://www.dbForumz.com/ This article was posted by author's request
Articles individually checked for conformance to usenet standards
Topic URL: http://www.dbForumz.com/PHP-SQL-expo...ict129471.html
Visit Topic URL to contact author (reg. req'd). Report abuse: http://www.dbForumz.com/eform.php?p=432359
Jul 17 '05 #6
> Jaunty Edward wrote:
can anybody refer me to a tool so that i can upload data from my local mysql DB to server DB without phpmyadmin. I have FTP and other access to server. my DB is like 100 MB.

I use MySQLPHPbak to make backups files (sql files), thise you can

then upload to another server and import into mysql with the
"\. /path/to/mysql_data_file.sql".

It seems like version 0.2.2 was the last version released, but havenít found any place where to download that one. Zend does have version 0.1.1 on their homepage, I suggest you make a search for "MySQLPHPbak" at google.com.
//Aho


Letís also mention brute force copy of data. You can:
(a) pkzip all the files in your db directory (tables, indecis, etc.)
(b) copy the zipped file to remote server
(c) if you have ssh, unzip the data into the db directory on remote
server
(d) repair tables
If you donít have ssh, then if you have proper access, you can copy
the files via ftp to remote server. It helps if both servers are
taken down when you are doing the above.

--
http://www.dbForumz.com/ This article was posted by author's request
Articles individually checked for conformance to usenet standards
Topic URL: http://www.dbForumz.com/PHP-SQL-expo...ict129471.html
Visit Topic URL to contact author (reg. req'd). Report abuse: http://www.dbForumz.com/eform.php?p=432411
Jul 17 '05 #7
In article <lY*****************@roc.nntpserver.com>, steve wrote:
I am interested in incremental backups of my mysql dbís, since they
are too large. Is this the right solution for that?


You can dump the database to a textfile.
And then use something like duplicity to store only an incremental file
on the backup server.

--
Tim Van Wassenhove <http://home.mysth.be/~timvw>
Jul 17 '05 #8
steve wrote:
Letís also mention brute force copy of data. You can:
(a) pkzip all the files in your db directory (tables, indecis, etc.)
(b) copy the zipped file to remote server
(c) if you have ssh, unzip the data into the db directory on remote
server
(d) repair tables


This requiers that you

1. Have total controll of the server in question (root access).
2. You don't have other data/users in the database on the remote server.
//Aho
Jul 17 '05 #9
steve wrote:
I am interested in incremental backups of my mysql dbís, since they
are too large. Is this the right solution for that?


Then you need somehow to compare the two databases, if it's possible to adjust
the data on the remote server.

If you use MySQLPHPbak, you could always save the latest file you got out for
the database in question, and when you take out a new one, you just make a
"patch" file, which will then only contain the difference between the two
files and then upload the "patch" and run it in mysql.

There may be a lot better options, but that is what I can think of on short hand.
//Aho
Jul 17 '05 #10

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

11 posts views Thread by Mike MacSween | last post: by
6 posts views Thread by maricel | last post: by
1 post views Thread by Holly | last post: by
12 posts views Thread by =?Utf-8?B?YXVsZGg=?= | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.