![]() ![]() In a Synology NAS server, the default place we put our sites is usually under the /web folder. Now, we have to determine, where exactly in our target system (this our Synology NAS server), we will transfer the entire macOS WordPress folder structure. Transferring the whole WordPress folder/file structure from macOS to the Synology NAS server ![]() ➜ mysqldump -user=root macdbwp1 > macdbwp1.sqlĭrwxr-xr-x 27 zp staff 864 Jan 10 18:11. We will use it later and we will import it in a same database schema in the target system MariaDB?MySQL. The sqldump outputs an sql script file with the name specified (‘ macdbwp1.sql’) which is a full export of our data in the macdbwp1 database. usr/local/var/However, you can use an absolute path as well. NB: The output sql script ‘ macdbwp1.sql’ file will be generated at the folder where the user is, at the moment of execution of the command above (e.g. If it contains non-standard characters, you should include it in single quotes. NB: Please, take care to correctly write your password. So, for the macdbwp1 database we can use: $ mysqldump -user=root macdbwp1 > macdbwp1.sql We have to use the mysqldump command (in bash shell): The same is also true for the user/owner (‘ macuserwp1‘) of that schema. Later, we should use the same database name (‘ macdbwp1‘) to create a brand new database schema on the target system’s MariaDB/MySQL. Type '\c' to clear the current input statement. Commands end with or \g.Ĭopyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others. using the statement: SHOW DATABASES and the sql command: SELECT User From er ): ➜ ~ mariadb -u root -p Any time you can also enter to macOS MariaDB and check them (e.g. These are defined in the macOS MariaDB database. ** WordPress should use to write directly to the filesystem (not via FTP) */įor the above example, the site’s database schema is ‘ macdbwp1’ and the user/owner is the ‘ macuserwp1’ user. */ĭefine( 'DB_COLLATE', 'utf8mb4_unicode_ci' ) ** Database Charset to use in creating database tables. ** The name of the database for WordPress */ Open the wp-config.php file and check the site’s database and the user/owner: // ** MySQL settings - You can get this info from your web host ** // rw-r-r- 1 zp staff 2496 wp-links-opml.php rw-r-r- 1 zp staff 351 wp-blog-header.php NB: This is defined using the DocumentRoot directive, inside the default Apache configuration file: usr/local/etc/httpd/nf.Īs you can see below, our site’s folder is (full pathname: /usr/local/var/➜ pwdĭrwxr-xr-x 13 zp admin 416 Dec 10 11:51 1 zp staff 6148 Nov 23 18:17 1 zp staff 523 Jan 2 12:23 1 zp admin 194 Nov 20 14:53 index.html ![]() In a MAMP (installed via Homebrew) various ‘sites’ can be found under the folder: The site’s users should be preserved during the transfer, and they can also be used later on, to login into the Dashboard (/wp-admin) of the new (transferred) site.Ĭheck the folder/file structure of the DocumentRoot at macOS We can check the site’s already define users, via the phpMyAdmin web interface:Īs you can see above, there are 2 users defined for the WordPress site. General Settings WordPress and URL addresses (Site name) Plugins Settings (This actually is: /index.php/%year%/%monthnum%/%day%/%postname%/) Users Keep aside important information, such as: First, we will inspect all the vital WordPress information of the macOS site, and put it aside for any necessary adjustments on the target Synology NAS server. Below, you can also find links to access all necessary steps to install and use the main MAMP stack components on macOS:Īctually, we are going to transfer the present site you see, from my MacBook Pro to my Synology NAS server. In case you don’t have yet installed Homebrew on your macOS, you can proceed and install it following the instructions here. It is supposed that you use a LAMP/MAMP stack on your macOS installed via Homebrew. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |