Difference between revisions of "Omen dev"
From Wiki2
(→MySQL) |
(→MySQL) |
||
Line 40: | Line 40: | ||
or mo better with /root.my.cnf no user password needed | or mo better with /root.my.cnf no user password needed | ||
[mysqldump] | [mysqldump] | ||
user=root | user=root | ||
password= | password=dfff | ||
then run | then run | ||
bash dump.sh | bash dump.sh | ||
Line 50: | Line 48: | ||
#!/bin/sh | #!/bin/sh | ||
mysqldump --all-databases > dump.sql | mysqldump --all-databases > dump.sql | ||
then get the data from the remote server | |||
sftp root@sitebuilt.net:/root/data/*.sql /data/MySQL | |||
sftp root@sitebuilt.net:/root/*.sql /data/MySQL | do the /home/tim/.my.cnf thing on omen | ||
[mysqldump] | |||
user=root | |||
password=nff | |||
[mysql] | |||
user=root | |||
password=gg | |||
then | |||
MySQL < dump.sql |
Revision as of 17:03, 22 June 2018
omen development env
references
docker
- https://nickjanetakis.com/blog/setting-up-docker-for-windows-and-wsl-to-work-flawlessly
- https://medium.com/@sebagomez/installing-the-docker-client-on-ubuntus-windows-subsystem-for-linux-612b392a44c4
npm
tips
sudo -i sets you as superuser
systemctl doesn't work use
/etc/init.d/php7.0-fpm restart
or
service nginx restart
when editng files you need to set permissions
chmod 644 info.php
Numeric Readable Explanation 0 --- No access. 1 --x Execute access.* 2 -w- Write access.** 3 -wx Write and execute access.*** 4 r-- Read access. 5 r-x Read and execute access. 6 rw- Read and write access. 7 rwx Read, write and execute access.
startup
sudo service nginx start sudo service mysql start sudo service php7.0-fpm start
MySQL
mysqldump -uroot -pnji9ol --all-databases > dump.sql mysqldump -uroot -pthepass --opt geniot > geniot.sql
or mo better with /root.my.cnf no user password needed
[mysqldump] user=root password=dfff
then run
bash dump.sh
which is
#!/bin/sh mysqldump --all-databases > dump.sql
then get the data from the remote server
sftp root@sitebuilt.net:/root/data/*.sql /data/MySQL
do the /home/tim/.my.cnf thing on omen
[mysqldump] user=root password=nff [mysql] user=root password=gg
then
MySQL < dump.sql