In SQL Server Management Studio right-click your database and select Tasks / Generate Scripts. Follow the wizard and you’ll get a script that recreates the data structure in the correct order according to foreign keys. On the wizard step titled “Set Scripting Options” choose “Advanced” and modify the “Types of data to script” option to … Read more
zcat /path/to/file.sql.gz | mysql -u ‘root’ -p your_database > will write the output of the mysql command on stdout into the file myfile.sql.gz which is most probably not what you want. Additionally, this command will prompt you for the password of the MySQL user “root”.
For wp-content folder you need to add WP_CONTENT_DIR with path to this folder to each wp-config.php file of each your sites. All of these WP_CONTENT_DIR constants should have the same path to one folder. Read more about it here: http://codex.wordpress.org/Editing_wp-config.php#Moving_wp-content To share the same database, you just need to setup the same database settings in … Read more
This is due to a new flag that is enabled by default in mysqldump 8. You can disable it by adding –column-statistics=0. The command will be something like: mysqldump –column-statistics=0 –host=<server> –user=<user> –password=<password> Check this link for more information. To disable column statistics by default, you can add [mysqldump] column-statistics=0 to a MySQL config file, … Read more
Preface It would be best to see what kind of caching options are available through your host. If you can use an object cache, CDN, or anything like that, you could decrease the load on your server. If your database and webserver are the same host, then storing this in the database won’t necessarily mean … Read more
You shouldn’t be using mysql_num_rows() or mysql_error() when dealing with $wpdb. Even if you weren’t, mysql_error() is for database errors, and an empty result set is not a database error. If you want to know if results were returned, simply check the count() of the results: $duplicateEmail = $wpdb->get_results($emailTest, OBJECT); if ( count( $duplicateEmail ) … Read more
You can create a new wpdb object and connect to an external MySQL database, though there will be a performance cost to making a remote connection, don’t expect it to be fast. But, you mentioned it’s an MS SQL database, not MySQL. There won’t be a WordPress based mechanism to do this, you’ll have to … Read more
From MySQL reference: Permitted characters in unquoted identifiers: ASCII: [0-9,a-z,A-Z$_] (basic Latin letters, digits 0-9, dollar, underscore) Extended: U+0080 .. U+FFFF Permitted characters in quoted identifiers include the full Unicode Basic Multilingual Plane (BMP), except U+0000: ASCII: U+0001 .. U+007F Extended: U+0080 .. U+FFFF ASCII NUL (U+0000) and supplementary characters (U+10000 and higher) are not … Read more
But I would like to use my secondary database connection like a standard WordPress query, so that all of the query builder functions are available. Unless the other database is a WordPress database, with the exact same table structure, you can’t. The query builder functions in WordPress are designed and built only to work with … Read more
There is no programmatic way to get a list of default tables. WordPress does not store a list of them anywhere. The closest thing there is is wp_get_db_schema(). This function returns the raw SQL used to create the default tables, but as you can see from the source, it doesn’t derive it from another source, … Read more