« previous next »
Pages: [1]

Author Topic: how to chop up a sql file?  (Read 3755 times)

0 Members and 1 Guest are viewing this topic.

Offline mentally

  • Newbie
  • *
  • Posts: 24
    • View Profile
how to chop up a sql file?
« on: August 08, 2005, 07:25:51 AM »
anyone know how to chop up a sql file into a bunch of smaller ones?

im moving my site to a new server but the sql file is HUGE so i cant import it all at once and copying and pasting will take forever

thanks
Logged

TheOracle

  • Guest
Re: how to chop up a sql file?
« Reply #1 on: August 08, 2005, 01:34:20 PM »
The quickest way to do so would be by saving the tables seperately.
Logged

Offline V@no

  • If you don't tell me what to do, I won't tell you where you should go :)
  • Global Moderator
  • 4images Guru
  • *****
  • Posts: 17.849
  • mmm PHP...
    • View Profile
    • 4images MODs Demo
Re: how to chop up a sql file?
« Reply #2 on: August 09, 2005, 12:28:59 AM »
use any text editor (notepad would work)
Logged
Your first three "must do" before you ask a question:
Please do not PM me asking for help unless you've been specifically asked to do so. Such PMs will be deleted without answer. (forum rule #6)
Extension for Firefox/Thunderbird: Master Password+    Back/Forward History Tweaks (restartless)    Cookies Manager+    Fit Images (restartless for Thunderbird)

TheOracle

  • Guest
Re: how to chop up a sql file?
« Reply #3 on: August 09, 2005, 12:34:21 AM »
@mentally :

If you intend to use a text editor, I'd recommend not to save your SQL file in binary mode but in ' ASCII ' mode. ;)

Althought, if these options cannot be selected from your SQL editor, you'd need a better text editor (such as: DzSoft PHP Editor for example) to load-up your SQL file safely - in order to be parsed from binary into text mode.
Logged
Pages: [1]
« previous next »