How do i put my database into a .sql file

Results 1 to 7 of 7
  1. #1
    Member MeanVale is offline
    MemberRank
    Sep 2007 Join Date
    91Posts

    How do i put my database into a .sql file

    Hi,

    Ive tried to copie the files in MySQL/Data but when the server is up some on the NPCs say the templates are missing.

    How do you compile the files into .sql?


    Thanks.
    Last edited by MeanVale; 22-10-07 at 05:43 PM.


  2. #2
    Account Upgraded | Title Enabled! mgX^ is offline
    MemberRank
    Feb 2006 Join Date
    DenmarkLocation
    512Posts

    Re: How do you complile your files?

    .sql aint compiled stuff....

  3. #3
    Member MeanVale is offline
    MemberRank
    Sep 2007 Join Date
    91Posts

    Re: How do you complile your files?

    Quote Originally Posted by mgX^ View Post
    .sql aint compiled stuff....
    Ok my bad, what is it and how do i put all my database into .sql

  4. #4
    Account Upgraded | Title Enabled! mclarkey08 is offline
    MemberRank
    Oct 2007 Join Date
    England, UKLocation
    428Posts

    Re: How do i put my database into a .sql file

    i Can only help if you're using SQLyog.!
    Okay, right click you're server's database, look down the menu until you find "Backup Database as SQL Dump File". Click That, Then you'll work out the rest, piss easy really :)
    Hope this Works
    Matt

  5. #5
    Member MeanVale is offline
    MemberRank
    Sep 2007 Join Date
    91Posts

    Re: How do i put my database into a .sql file

    Quote Originally Posted by mclarkey08 View Post
    i Can only help if you're using SQLyog.!
    Okay, right click you're server's database, look down the menu until you find "Backup Database as SQL Dump File". Click That, Then you'll work out the rest, piss easy really :)
    Hope this Works
    Matt
    Hi

    I did that earlier, i tried to then run the sql dump and it got to about 800 and i got error messages, i opend it and it said stuff like
    ascent.vendor not found.

  6. #6
    Enthusiast Ab3 is offline
    MemberRank
    Apr 2007 Join Date
    BucharestLocation
    33Posts

    Re: How do i put my database into a .sql file

    Quote Originally Posted by MeanVale View Post
    Hi

    I did that earlier, i tried to then run the sql dump and it got to about 800 and i got error messages, i opend it and it said stuff like
    ascent.vendor not found.
    i had the same problem
    then i created a new database with a new name and used the new one
    if you want to back-up the database in case you reinstall mysql, you can copy the file named after your database in your mysql folder

  7. #7
    Account Upgraded | Title Enabled! mclarkey08 is offline
    MemberRank
    Oct 2007 Join Date
    England, UKLocation
    428Posts

    Re: How do i put my database into a .sql file

    Hmm, Dno wats wrong then :P Sorru



Advertisement