• Disable replication on MySQL database

    For the past month of so, I've been running dual master MySQL replication but now I need to move to just one database that doesn't have a replication. Is there a way to completely disable replication on each database? Thank you

    ITKE413,620 pointsBadges:
  • InnoDB: Shrink file without having to dump and re-import database

    I'm using InnoDB and it's storing all of my info in one big file. I went in and removed a big table but the file still keeps the same size. Is there a way I can shrink that file without dumping and re-importing my whole database. Thank you very much.

    ITKE413,620 pointsBadges:
  • SQL Server 2008: Shrink database files

    In SQL Server 2008, is there a way I can shrink my files (log and data) on all of my databases? I've already tried to use SSMS and right click each one but that's way too slow. Is there anything faster?

    ITKE413,620 pointsBadges:
  • SQL Server: Get database name

    How do I get the database name and associated user mapped for all database in SQL Server?

    testsdf5 pointsBadges:
  • Can I mysqldump specific tables in my database?

    In MySQL, is there a way I can dump a specific table / tables without including the remaining database tables? I would appreciate the help.

    ITKE413,620 pointsBadges:
  • Is it possible to set up a PHP-based Q&A module without a database?

    I'd like to set up a PHP-based Q&A module that doesn't require any kind of database. For example, a user would fill out a form asking a question, and then click on a submit button to send it to a moderator. The moderator would then instantly receive the question and have the ability to modify...

    ygagnon20 pointsBadges:
  • MySQL: Reduce size of ibdata

    We have several production servers that have IBDATA files. These files are increasing daily. Actually, it's almost taken up 300 GB in space. The tables in the servers are InnoDB (most are read and write requests). Also, log file size is going up too. So basically, data continues to rise. Is there a...

    ITKE413,620 pointsBadges:
  • Using two same files from different libraries in a RPGLE program.

    Hi All, Please guide me for the following problem. I got stuck into it. I want to operate same file from two different libraries in a RPGLE program. Remember we are taking the file names at runtime. So we don?t know the structure of files. Like the record format name etc. Again somehow I retrieve...

    navinnegi45 pointsBadges:
  • What is arc viewing in databases?

    How does arc viewing connect to sampling points in data bases?

    BudMeee20 pointsBadges:
  • We’re looking to add a field description in a DB2/400 file

    My partner and I have a set of files on an AS/400 system but we don't have DDS for (the files were created in SQL). We would like to add field descriptions but we're struggling to find how to do this in AS/400.Could someone tell me how we can add a field description? Is directly updating...

    ITKE413,620 pointsBadges:
  • Record format in DB2/400

    How to check file name using record format in DB2/400?

    vishwaraj60 pointsBadges:
  • DB2 to Text File Conversion and Transfer

    I have created a Text File from my AS/400 DB2 table. I want to transfer this file from one iSeries system to another. How to do this?

    gvdsswami20 pointsBadges:
  • Reading a file twice in CL

    I declared a file in CL. I read all the records, i.e End Of File has reached. Now again i want to read he file from beginning within the same program.I tried with OVRDBF and POSDBF.But could not succeed.Can any body help me?

    Kumari0 pointsBadges:
  • Many to one relationship in Microsoft Access query

    I have the following tables: ISSUEREASONS(issueID, issueReason = "PNR Change"), Issues(issueID, partNumber), Parts(PartNumber, DDSID), PNR(PNR, DDSID, PNRChangeReason="PNR Change") where there is mostly all one to one relationships besides there is multiple PNR to DDSID. I need to query for both...

    tabooka15 pointsBadges:
  • Microsoft Access: How to create an entry form for a team event with up to 4 members on each entry form

    I am trying to create an entry form (order form) for a golf event. (There are 5 events per year.) Each event is a team event, involving 4 entrants (members.) So I want the entry form to have the event name once, but each of the four members' names on the entry form. I am having great difficulty...

    janeyr5 pointsBadges:
  • How do insert many images (BLOB) into a SQL Server table

    How do I insert several images (BLOB) in to a SQL Server table?

    cjohnNewVIc5 pointsBadges:
  • Advantages of database system over file systems

    What are the advantages of database system over file systems?

    Michael Tidmarsh47,340 pointsBadges:
  • Microsoft Access 2016 MSO – How to save data to Table A

    I don't know if the table has to be attached to the form to copy to the table and do I have to click save or does each record save when I reach the end of the row

    dannyboy14145 pointsBadges:
  • How to install Apache with MySQL and PHP on Linux CentOS?

    Hello, How can I install Apache with MySQL and PHP on Linux CentOS? Thank you!

    isophiawilson155 pointsBadges:
  • Open IT Forum: Tell us your must-read IT blog or Twitter feed & earn 50 knowledge points!

    We're always looking for great resources to share with the community, so here's your chance to share what's in your own bag of tricks! Share your favorite IT blogs or Twitter personalities, what they write about, or a link to a post that taught you something you'll never forget. Don't have a...

    MelanieYarbrough6,345 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following