To connect to your remote MySQL database server using MySQL Workbench, you have to allow remote connections to the server. ![]() NOTE: This section assumes that you have downloaded and installed MySQL Workbench. The output of the command indicates which database server (MySQL or MariaDB) is used by the installation, and will allow you to identify which guides to follow in our documentation for common database-related operations. To identify which database server is used in your stack, run the command below: $ test -d /opt/bitnami/mariadb & echo "MariaDB" || echo "MySQL" On account of these changes, the file paths and commands stated in this guide may change depending on whether your Bitnami stack uses MySQL or MariaDB. It took a long time but it did work.NOTE: We are in the process of modifying the configuration for many Bitnami stacks. Save the file and restore it using Backup Migrate module. This was causing the syntax error when I attempted to restore the database backup on the local dev version of the site.Ĥ. My staging server was adding comments to the first 5 lines of my backup files. Open this backup file in your text editor and remove the comments at the beginning of the file. Backup your existing Drupal website without compression.ģ. The cache tables are super large and will make your database restore process time out because it takes far too long.Ģ. This is setup by default in your backup profile settings. Make sure your database backup using Backup Migrate omits the data from the cache tables. I made a backup using the Backup Migrate module and attempted to restore it on my local dev site.ġ. I encountered the same error message when I tried to restore the database backup. Drupal created database tables and populated them, everything else (during the installation phase, that is) worked like a charm. Just before pressing the button of the install-screen with database settings, that is just before drupal installation writes everything to the settings.php, at that time I copied my "ready" settings.php and made it readonly. I created a correct settings.php, with $base_url, database settings and reverse proxy settings. Well.ĭuring installation, after the database settings, the file settings.php was written, which destroyed my settings of $base_url (and reverse proxy related settings) which somehow made creation and population of database tables to fail, resulting in above error message. I had to edit the settings.php and set $base_url to the correct servername, otherwise I got the IP-adress (10.0.0.10) in all html-code generated by drupal, which resulted in long response time and missing stylesheets and images. I have Nginx as reverse proxy and apache, php, mysql, drupal running in a FreeBSD jail. ![]() ![]() It was (for me) an issue with installing on a reverse proxy. Returning to my sub-sites i ve got this error:Įrror message PDOException: SQLSTATE: Syntax error or access violation: 1064 You have an error in your SQL syntax check the manual that corresponds to your MySQL server version for the right syntax to use near ') ORDER BY fit DESC LIMIT 0, 1' at line 1: SELECT * FROM WHERE path IN () ORDER BY fit DESC LIMIT 0, 1 Array ( ) in menu_get_item() (line 445 of /s/usr-local/In the apache log I see this:ġ0.0.0.10 - "GET /drupal/ HTTP/1.0" 500 3676 " " "Mozilla/5.0 (Macintosh Intel Mac OS X 10_6_7) AppleWebKit/534.30 (KHTML, like Gecko) Chrome/12.0.742.112 Safari/534.30" Recently i ve got problems to connect my drush because of the ssh keys so I tired to update the keys by adding an RSA key and authorize it. Third run drush to install modules on the main site to get them shared and the themes with the subsites Second i ve got a domain with a site and run multiple sub-domains
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |