数据库备份 - 如何? [英] database backup - how to?
问题描述
如何将家用电脑的MySQL表格数据与远程服务器的最新数据
同步?
我的家用电脑速度非常慢互联网连接,所以实施
复制会导致远程服务器长时间读锁,这是不可取的。
不可取。
什么用于手动同步表格的工具?
我在家用电脑上运行FreeBSD。
Mike
siliconmike写道:
手动同步表有哪些工具?
如果数据库的大小不是太大:
使用mysqldump创建整个数据库的转储。使用gzip或类似的
工具将其缩小以进行传输。在您的计算机上,将其解压缩
并使用mysql命令行工具读取它。
您可以使用mysqldump仅获取给定的表,以防您habe非常
大型静态表和几个小动态表。
Aggro写道:< blockquote class =post_quotes> siliconmike写道:
手动同步表有哪些工具?
如果数据库的大小是不要太大:
使用mysqldump创建整个数据库的转储。
哦哦!表是Biiiiiiiiiiiiiigigggggg !!
siliconmike写道:如何将家用PC的MySQL表数据与最新数据同步
来自远程服务器?
我的家用电脑连接速度非常慢,因此实施复制会导致远程服务器长时间读锁,这是
不可取。
手动同步表的工具是什么?
我在家用电脑上运行FreeBSD。
迈克
Mike,
如果你可以修改服务器上的程序让他们写下
将服务器数据库插入或更新为
平面文件的SQL语句。下载平面文件并在家中运行
PC数据库。
只要每个SQL语句都用分号终止
您可以使用以下方法执行平面文件的内容:
mysql -u user_name database_name< flat_file_name
HTH
Jerry
How do I synchronize MySQL table data of my home PC with latest data
from a remote server ?
My home PC is on a very slow internet connection, so implementing
replication will cause long time read lock on remote server, which is
not desirable.
What are the tools for manual sync of tables ?
I''m running FreeBSD on my home PC.
Mike
siliconmike wrote:
What are the tools for manual sync of tables ?
If the size of database is not too big:
Use mysqldump to create dump of the whole database. Use gzip or similar
tool to make it smaller for the transfering. On your computer, unzip it
and read it in using mysql-command line tool.
You can use mysqldump to get only given tables, in case you habe very
large static table and few small dynamic tables.
Aggro wrote:siliconmike wrote:What are the tools for manual sync of tables ?
If the size of database is not too big:
Use mysqldump to create dump of the whole database.
Oh O! The tables are Biiiiiiiiiiiiiiiigggggggg!!
siliconmike wrote:How do I synchronize MySQL table data of my home PC with latest data
from a remote server ?
My home PC is on a very slow internet connection, so implementing
replication will cause long time read lock on remote server, which is
not desirable.
What are the tools for manual sync of tables ?
I''m running FreeBSD on my home PC.
Mike
Mike,
If you can modify the programs on the server have them write the
SQL statements that insert or update your server database to a
flat file. Download the flat file and run it against your home
PC database.
As long as every SQL statement is terminated with a semi-colon
you can execute the contents of your flat file using:
mysql -u user_name database_name < flat_file_name
HTH
Jerry
这篇关于数据库备份 - 如何?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!