large database
Moderator: General Moderators
large database
excuse my n00bness. ive only used phpmyadmin when dealing with databases (mysql). my question is how do i upload a database that is larger than what phpmyadmin will allow? do i export the database and save it as a php file and run the page?
Set Search Time - A google chrome extension. When you search only results from the past year (or set time period) are displayed. Helps tremendously when using new technologies to avoid outdated results.
- Chris Corbyn
- Breakbeat Nuttzer
- Posts: 13098
- Joined: Wed Mar 24, 2004 7:57 am
- Location: Melbourne, Australia
Well the actual import query is:
If you have access to a command line version of the mysql client on your server just import the dump in that way.
If not: (I've never tried this), try running that query from within php.
You can just upload the file by FTP... or use SCP and SSH if you have shell access since you should definitely be able to import that data in that way 
Code: Select all
mysql> \. /path/to/sql/dump.sql
.... (Inserting data etc etc...)If not: (I've never tried this), try running that query from within php.
Code: Select all
mysql_query("\\. /path/to/sql/dump.sql") or die (mysql_error());- n00b Saibot
- DevNet Resident
- Posts: 1452
- Joined: Fri Dec 24, 2004 2:59 am
- Location: Lucknow, UP, India
- Contact:
- Chris Corbyn
- Breakbeat Nuttzer
- Posts: 13098
- Joined: Wed Mar 24, 2004 7:57 am
- Location: Melbourne, Australia
- n00b Saibot
- DevNet Resident
- Posts: 1452
- Joined: Fri Dec 24, 2004 2:59 am
- Location: Lucknow, UP, India
- Contact:
I also thought so... but I had only FTP access so i couldn;t go for cmdline optiond11wtq wrote:It's most likely that the web server itself is timing out rather than phpMyAdmin.
Yeah! CMDLINE ROCKS! Makes you a geekd11wtq wrote:I prefer the command line anyway (I like to watch all those "Query OK, 1 rows affected" messages whizz past my eyes)