SATEL
ACCO NET
65
3. Copy the essential database file to the new system by entering the command:
scp accoDb.sql [email protected]:/home/rjones/accoDb.sql
and pressing ENTER.
The following random data are used in the command:
rjones – name of the new system user;
192.168.9.12 – IP address of the device on which the new system is installed;
/home/rjones – name of the “rjones” user's home directory. This directory is created
during the procedure of adding a user to the system. The exported database files will
be copied to this directory.
4. Enter the rjones user's password valid in the new system and press ENTER.
5. Copy the temporary database file to the new system by entering the command:
scp accoDb_temporary.sql
[email protected]:/home/rjones/accoDb_temporary.sql
and pressing ENTER.
6. Enter the rjones user's password valid in the new system and press ENTER.
8.3.5 Importing databases
In the console window, on a computer or virtual machine with new versions of the Debian and
ACCO NET systems installed:
1. Log in as the root administrator.
2. Check whether the database files have been copied to the required directory, and
whether the date of the copy and the size of the copied files are correct by entering the
command:
ls –lh /home/rjones/*.sql
and pressing ENTER.
3. Go to the directory to which the database files from the old system have been copied by
entering the command:
cd /home/rjones
and pressing ENTER.
4. Log in to the database by entering the command:
mysql
– if the root administrator of the MySQL database has no password assigned
and pressing ENTER;
mysql –u root –p
– 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. Import the copied essential database file to the new system by entering the command:
SOURCE accoDb.sql
and pressing ENTER.
6. Import the copied temporary database file to the new system by entering the command:
SOURCE accoDb_temporary.sql
and pressing ENTER.
7. Grant the
accoweb
user privileges on the accoDb database by entering the command:
GRANT ALL ON accoDb.* TO 'accoweb'@'%';
and pressing ENTER.
