Article View: cn.bbs.comp.database
Article #16Re: sql�ļ���ʧ�ˣ���ô�ָ���ݿ⣿
From: Galaxy��VOLUNTEERS��Database
Date: Wed, 30 Sep 2009 03:13
Date: Wed, 30 Sep 2009 03:13
25 lines
2414 bytes
2414 bytes
google ��һ��: 2�������ڱ��ػ�����װmysql��ݿ�ת��*.frm,*.myd,*.myi���ļ�Ϊ*.sql�ļ��� 1�����Ȱ�װmysql����ð汾�ͷ�����һ�£�����ҲҪһ�£���һ�µ�����к���֢�� ���룩�� 2��Ȼ���ý������� �����µ���ݿ��������£� create database name;(������Ϊname����ݿ�Ǻǡ�����������) Ȼ��ȥ�㰲װ�� mysqlĿ¼�µ�data�ļ����¾��и�name�ļ��С� 3�������*.frm,*.myd,*.myi�ļ�ͳͳ��P��data�ļ����¡� 4��Ȼ����������ʾ���½��뵽mysql ��װĿ¼��binĿ¼�� ���е���Ϊ*.sql�ļ��� mysqldump -uroot -p name > name.sql�� �����Ժ������������Ҫ�Ļ���Ҫ��DZ���. �� �� moodlysea ( �쳾����) �Ĵ������ᵽ: �� : ����ϵͳ��SERVER 2003��PHP+MYSQL������վ��ݿ��ļ�SQL�㶪�ˣ���������FRM��MYD�� : MYI�ļ������ʸ���ô�ָ�����غ������վ����ʷ���ϣ���ͽ̣� -- Welcome to Database Board ��ӭ������ݿ�� http://bbs.sjtu.edu.cn/bbsdoc?board=database [m[1;31m�� ��Դ:����ˮ˼Դ bbs.sjtu.edu.cn��[FROM: 207.46.55.30][m
Technical Details
Message-ID:
<4iDOOE$aqh@bbs.sjtu.edu.cn>Path:
arc1-ca.pugleaf.net!g2news2.google.com!news3.google.com!feeder3.cambriumusenet.nl!feed.tweaknews.nl!192.87.166.28.MISMATCH!tudelft.nl!txtfeed1.tudelft.nl!newsfeed.straub-nv.de!newsfeed01.sul.t-online.de!t-online.de!61.160.212.82.MISMATCH!www.shinco.com!news.shec6.edu.cn!SJTUShow Full Headers
Complete Article Headers
X-Google-Thread: 4df683fd51,2fcfd40bc6bd922d,start X-Google-Attributes: gid4df683fd51,public,usenet X-Google-NewGroupId: yes X-Google-Language: Chinese,GB Path: arc1-ca.pugleaf.net!g2news2.google.com!news3.google.com!feeder3.cambriumusenet.nl!feed.tweaknews.nl!192.87.166.28.MISMATCH!tudelft.nl!txtfeed1.tudelft.nl!newsfeed.straub-nv.de!newsfeed01.sul.t-online.de!t-online.de!61.160.212.82.MISMATCH!www.shinco.com!news.shec6.edu.cn!SJTU From: Dem.bbs@bbs.sjtu.edu.cn (Galaxy��VOLUNTEERS��Database) Newsgroups: cn.bbs.comp.database Subject: Re: sql�ļ���ʧ�ˣ���ô�ָ���ݿ⣿ Date: 30 Sep 2009 03:13:12 GMT Organization: ��ˮ˼Դ Message-ID: <4iDOOE$aqh@bbs.sjtu.edu.cn> Mime-Version: 1.0 Content-Type: text/plain; charset="gb2312" Content-Transfer-Encoding: 8bit X-Filename: database/M.1254280334.A Lines: 25