64
ACCO NET
SATEL
In the console window, on the computer or virtual machine where the databases are located:
1. Log in as the root administrator.
2. Stop the ACCO Server program by entering the command:
service acco-server stop
and pressing ENTER.
3. Go to the directory to which you want to export the SQL files by entering the command:
cd /home/asmith
and pressing ENTER.
The following random names are used in the command:
asmith – name of user of the existing system;
/home/asmith – name of the “asmith” user's home directory. This directory is created
during the procedure of adding a user to the system.
4. Export the essential database named accoDb to the SQL file by entering the command:
mysqldump --databases accoDb --routines > accoDb.sql
– if the root administrator of
the MySQL database has no password assigned
and pressing ENTER;
mysqldump –u root -p --databases accoDb --routines > accoDb.sql
– if the root
administrator of the MySQL database has a password created
and pressing ENTER, and then entering the password and pressing ENTER again.
5. Export the temporary database named accoDb_temporary to the SQL file by entering the
command:
mysqldump --databases accoDb_temporary --routines > accoDb_temporary.sql
– if
the root administrator of the MySQL database has no password assigned
and pressing ENTER;
mysqldump
–u
root
-p
--databases accoDb_temporary --routines >
accoDb_temporary.sql
– if the root administrator of the MySQL database has
a password created
and pressing ENTER, and then entering the password and pressing ENTER again.
6. Check whether the database files have been exported to the required directory, whether
the export date and the size of the exported files are correct by entering the command:
ls –lh /home/asmith/*.sql
and pressing ENTER.
Two files will be saved in the /home/asmith directory:
accoDb.sql – essential database file exported;
accoDb_temporary.sql – temporary database file exported.
8.3.4 Copying databases from the old system to a new one
In the console window, on a computer or a virtual machine with the existing versions of the
Debian and ACCO NET systems installed:
1. Log in as the root administrator.
2. Go to the directory to which the SQL files have been exported by entering the command:
cd /home/asmith
and pressing ENTER.
