Assuming database is required, the following 112 results were found.
-
do about 5000 articles on each iteration so as to avoid session timeouts and memory issues. Edit the script, renaming the database and table names used (DO NOT CONFUSE THE FOLLOWING DATABASE NAMES OR YOU WILL END UP WITH NEITHER SITE WORKING!!!) Open...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
Framework Class Library Usage: MySql.Data.MySqlClient.MySqlConnection Manufacturer: MySQL Standard Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword; Default port is 3306. Specifying port...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server
- Language: *
-
following describes how to setup a database user with read-only access to the AdventureWorks database. Using SQL Server Management Studio 2008: Connect to your database server. Expand Security > Logins. Right-click on the user who will be set as having...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: *
-
This is an article on how to do a restore from backup on a database but when you get the error: "... database is in use". -- SQL Server 2005 EXEC SP_WHO // details on who is logged in GO -- SQL Server 2008 EXEC SP_WHO2 // even more details GO -- Run as...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: en-GB
-
1.6.x to 2.5.x. Because I use dynamic scripts running in the background (mootools), some of these need to connect to the database but as they sit outside of the MVC structure, we need them to use the existing configuration file in order to retrieve the...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
I've been looking into this for a friend and going through forums to investigate this error. After you've checked your database connection details, I find what FisherC said below is the most probable cause for the error. FisherC says: I have the same...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
Not Yet Available" as well as "Data not yet available". These are obviously the same values, so I should go through the database and change all variations to be typed the same way in the same case. Wouldn't it be nice to search through your entire...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: en-GB
-
This article isn't unique as there are other tutorials out there. This is meant to detail a process to export a database using MySQL Workbench and then to import it into another database. Why? If you're confined to use this product then this is how to...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
Should contain the following: create_countriesipranges_table.sql: SQL to create a pre-populated table into a MySQL database. iana_ipv4_address_space_registry.csv: comma separated values list of all countries, regions and their respective IP ranges....
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: *
-
This article assumes you are familiar with upgrading a Joomla! CMS and running MySQL statements against your database. For the purposes of this article, we will refer to the live/current/production website running Joomla v2.5 as "v25" and the new Joomla...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
A quick note as I had difficulty finding a clear answer on this. I need a cron job setup where the permissions for a database user is required to do a backup (reading and copying data from a LIVE database) to a copy of the database (inaccessible via...
- Type: Article
- Author: Joel Lipman
- Category: cPanel
- Language: *
-
I tried the SQL Server Management Studio solution to connect to a MySQL database then lost my way wondering what was I trying to achieve? I've written this article because this is how I connected to a MySQL database from within the Business Intelligence...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
for "wp-config.php" from LIVE to DEV Copy the salt and secret keys from LIVE\wp-config.php to DEV\wp-config.php Backup the database in LIVE environment Clear the database in DEV Copy database from LIVE to DEV Change database values: Navigate to...
- Type: Article
- Author: Joel Lipman
- Category: Wordpress
- Language: en-GB
-
I have a PHP script which behaves like PhpMyAdmin, in that it automatically lists a database structure and the fields to modify similar to an excel spreadsheet. Now without using PHP, I need standalone SQL scripts that can simply be used to search an...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: en-GB
-
We have a datawarehouse and we want to be able to count all the records in any table of the database that match on a particular warehouse load. This is a column value where the column is called "WarehouseLoadKey" and the value we want to search on is...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: en-GB
-
Apologies for posting yet another article on how to access the Joomla Database using the Joomla classes but this is just a quick note for myself as a reference sheet. Plus the official documentation don't have enough examples in my view. Source:...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
of your main website to another folder. Setup an FTP account to the new folder created in the previous step. Copy the database of your main site to another database. Setup a database user account that can access the new database created in the previous...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
ACL managers? How? In our case, the website had recently been migrated from Joomla 1.5.x to 2.5.x. I asked to examine the database and a quick scan in the assets table revealed 3 assets had the parent_id = 0. Only one asset can have that and that is...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
to: MySQL Database v5.0.45 MySQL Workbench v6.0.8.11354 build 833 What? This is a quick article on how to get around the problem of backing up your MySQL database when attempting to "Data Export" using MySQL Workbench. This is not regarding the...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: *
-
A quick article on how to populate a database column from another table using a string comparison. Why? I have several database tables which replicate country names and I would rather they all use the ccTLD two letter code. This article was written...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB