Re: Moving a MySQL database

From: Kirk Strauser (kirk_at_strauser.com)
Date: 08/22/03

  • Next message: Roberto Sanchez: "bash won't read in ~/.bashrc" 
    To: debian-user@lists.debian.org
Date: Fri, 22 Aug 2003 10:56:24 -0500

    At 2003-08-22T15:03:33Z, Roberto Sanchez <rcsanchez97@yahoo.es> writes:

    > I have a MySQL database residing on a RH9 server. I have started building
    > a Debian server running woody to replace it. Is there an easy way to grab
    > the whole database and move it over as is?

    1. Type: `mysqldump -u root -p -A --opt > file.sql'.

    2. Load the new server with: `mysql < file.sql'

    3. Connect to the new server and type: `flush privileges' to load the user
       tables that you imported in the previous step.

    4. Sit back and smile. 

    -- 
Kirk Strauser



    -- 
To UNSUBSCRIBE, email to debian-user-request@lists.debian.org 
with a subject of "unsubscribe". Trouble? Contact listmaster@lists.debian.org
  • Next message: Roberto Sanchez: "bash won't read in ~/.bashrc"

    Relevant Pages

    • Re: Design issue: Preload data or get on request
      ... > windows application that uses the data stored on an SQL server. ... > a number of different tables in the database. ... > required or load the data for each user request and not maintain any cache. ... the XML document at the web service server. ...
      (microsoft.public.dotnet.general)
    • Re: about structure.
      ... Of course if you want to use a load of checkboxes, it works too, just modify ... I thought about using a database... ... "I thought about using php... ... server needs to call upon php... ...
      (alt.php)
    • Re: True Memory Use
      ... We had to actually measure our server (it can handle 1300 ... You have to measure it under load. ... Note that you have to expect 70 seconds for a reverse DNS lookup; ... But of course the GUI *does* consume cycles, so only load simulation is ...
      (microsoft.public.vc.mfc)
    • IIS Slowdown
      ... We are running IIS 5.0 on Windows 2000 server. ... The website is connected to a database, ... database can take over a minute to load. ...
      (microsoft.public.windows.server.general)
    • Re: the future of applications in JavaScript?
      ... more than one server has to be up for success. ... I can't imagine that a brower rendering engine needs to be hand written ... One is make the browser smarter and have longer load times ...
      (comp.lang.javascript)