export local DB to Server DB

[Jaunty Edward]

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

[Andy Hassall]

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

[Andy Barfield]

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

[J.O. Aho]

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

[Andy Barfield]

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

[steve]

> 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

[steve]

> 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

[Tim Van Wassenhove]

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>

[J.O. Aho]

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

[J.O. Aho]

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