You can use mysqldump to create a simple backup of your database using the following syntax: Backup:  mysqldump -u [username] -p[password] -h[host] [databasename] > [backupfile.sql] Restore:  mysql -u [username] -p[password] -h[host] [databasename] <...

You can write one-line find-and-replace statements in SQL. To find a string in a certain field and replace it with another string: UPDATE [table_name] SET [field_name] = REPLACE([field_name],'[string_to_find]','[string_to_replace]'); To not affect date updated for the articles use following...

Normally it is not recommended to change variables that control MySQL fulltext index behaviour (such as ft_min_word_len or ft_max_word_len) but if you really need to... MySQL config file would usually be found on Windows under C:\Windows\my.ini and on Linux under /etc/my.cnf Edit the file and...

In an .htaccess file in the KBPublisher installation directory change and uncomment line: php_value memory_limit For example, if the desired limit is 32 MB, the following directive would be placed in the .htaccess: php_value upload_max_filesize "32M" If you are on windows with IIS...

In an .htaccess file in the KBPublisher installation directory change and uncomment line: php_value upload_max_filesize For example, if the desired filesize is 3 meg, the following directive would be placed in the .htaccess: php_value upload_max_filesize "3M" You also may want to...

To create the file simply add the following lines of code to a blank document and name the file phpinfo.php <?php phpinfo(); ?> Save the file as phpinfo.php and place it in the desired directory. Lastly, call the script from a browser. Example:...

A full server path is the path your system uses to define where your own files are located on the server (as opposed to files belonging to other users). You can determine the path while you are logged in via FTP (some programs will tell you this) or while using a File Manager tool in your...