So … sometimes you on shared hosting and you need to import a large database. Problem phpmyadmin only supports a max of > 50MB. So the first option is to check the php.ini or the cursed .htaccess file – however many times shared providers override these or won’t allow an apache restart immediately.
2- Open bigdump.php in a text editor, adjust the database configuration and dump file encoding.
3- Drop the old tables on the target database if your dump doesn’t contain “DROP TABLE” (use phpMyAdmin).
4- Create the working directory (e.g. dump) on your web server
5- Upload bigdump.php and the dump files (*.sql or *.gz) via FTP to the working directory (take care of TEXT mode upload for bigdump.php and dump.sql butBINARY mode for dump.gz if uploading from MS Windows).
6- Run the bigdump.php from your web browser via URL likehttp://www.yourdomain.com/dump/bigdump.php.
7- Now you can select the file to be imported from the listing of your working directory. Click “Start import” to start.
9- Relax and wait for the script to finish. Do NOT close the browser window!
— IMPORTANT: Remove bigdump.php and your dump files from your web server.
Start up SQL Anywhere Services from command prompt on NT
There are cases when customer would like to start up a SQL Anywhere Services at a specific time or after a database backup. The following is a way to start up a SQL Anywhere Services from outside Sybase Central or NT Services (as in Control Panel, Servi
Open the 32-bit registry editor (C:\WINNT\system32\regedt32.exe).
On the taskbar, click on “Start” then select “Run”. Type in regedt32 or regedit.
Double click on HKEY_LOCAL_MACHINE -> SYSTEM -> CurrentControlSet -> Services
For ASA versions 6.x.x/7.x.x/8.x.x, scroll down until you see ASANY. For SQL Anywhere version 5.x.x, scroll down until you see SQLANY. Any services created in SQL Anywhere Service Manager (or from Sybase Central) should be listed here.
The name of each individual service would appear as
ASANYx_y or SQLANYx_y
where ‘x’ represents the Service Type:
a – Sample Application
c – Client
e – Standalone Engine
l – Agent for Replication Server
o – Open Server Gateway
r – SQL Remote Message Agent
s – Network Server
and ‘y’ represents the Service Name as seen in the ‘Name’ column in Sybase SQL Anywhere Service Manager.
Find out which key is for the service you want to start from the DOS prompt. Write down the name of the key. Note that the key is
Case sensitive for version 5.x.x but is not case sensitive for version 6.x.x/7.x.x/8.x.x.
In DOS, the command to start up any registered NT Services (which include SQL Anywhere/Adaptive Server Anywhere Services) is ‘net start’.
Therefore, the syntax to start up a SQL Anywhere Service from a command prompt (DOS prompt) would be:
net start <key for the service from registry editor>
Similarly, the NT command to stop any registered NT Services is ‘net stop’
Therefore, the syntax to stop a SQL Anywhere/Adaptive Server Anywhere Service from a command prompt (DOS prompt) would be:
net stop <key for the service from registry editor>
Ever have a list of data and want to quickly check for duplicates. Now I know it’s possible in SQL or even Excel but if you looking for a really easy online way without tweaking check out http://www.somacon.com/p568.php – Paste your data in the form click on Display / Update Counts and view the results …